item-property-ado.md

title	Item Property (ADO) | Microsoft Docs
ms.prod	sql
ms.prod_service	connectivity
ms.technology	connectivity
ms.custom
ms.date	01/19/2017
ms.reviewer
ms.topic	conceptual
apitype	COM
f1_keywords	Parameters::GetItem Indexes::GetItem Parameters::Item Tables::Item Procedures::Item Users::GetItem Tables::GetItem Procedures::GetItem Users::get_Item Users::Item Views::GetItem Groups::Item Groups::get_Item Columns::Item Indexes::Item Fields15::GetItem Columns::GetItem Fields::Item Indexes::get_Item Columns::get_Item Fields15::Item Views::get_Item Groups::GetItem Errors::get_Item Fields15::get_Item Tables::get_Item Views::Item Errors::GetItem Parameters::get_Item Errors::Item Procedures::get_Item
helpviewer_keywords	Item property [ADO]
ms.assetid	e11484bb-c5c7-42d8-9bb8-21572125d727
author	MightyPen
ms.author	genemi

Item Property (ADO)

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

Syntax

Set object = collection.Item ( Index )  

Return Value

Returns an object reference.

Parameters

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)  

Applies To

Axes Collection (ADO MD)	Columns Collection (ADOX)	CubeDefs Collection (ADO MD)
Dimensions Collection (ADO MD)	Errors Collection (ADO)	Fields Collection (ADO)
Groups Collection (ADOX)	Hierarchies Collection (ADO MD)	Indexes Collection (ADOX)
Keys Collection (ADOX)	Levels Collection (ADO MD)	Members Collection (ADO MD)
Parameters Collection (ADO)	Positions Collection (ADO MD)	Procedures Collection (ADOX)
Properties Collection (ADO)	Tables Collection (ADOX)	Users Collection (ADOX)
Views Collection (ADOX)

See Also

Item Property Example (VB)
Item Property Example (VC++)