Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Item Property (ADO)
Collapse the table of content
Expand the table of content

Item Property (ADO)


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

Set object = collection.Item ( Index )

Returns an object reference.


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

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)
© 2015 Microsoft