Item property (ADO)

Applies to: Access 2013, Office 2013

Indicates a specific member of a collection, by name or ordinal number.

Syntax

Setobject = collection.Item ( Index )

Return value

Returns an object reference.

Parameters

Parameter Description
Index A Variant expression that evaluates either to the name or to the ordinal number of an object in a collection.

Remarks

Use the Item property to return a specific object in a collection. If Item cannot find an object in the collection corresponding to the Index argument, an error occurs. Also, some collections don't support named objects; for these collections, you must use ordinal number references.

The Item property is the default property for all collections; therefore, the following syntax forms are interchangeable:

    collection.Item (Index)
    collection (Index)