Item Property (Collections)

See Also Applies To

The Item property returns a specific member of a collection either by position or by index.

Setting

object.Item(index)

The Item property uses the following settings.

Setting	Description
object	One of the following collections:
	Controls Forms Modules Pages Reports Properties AccessObjectProperties DataAccessPages AllForms AllReports	AllDataAccessPages AllMacros AllModules AllTables AllQueries AllViews AllStoredProcedures AllDatabaseDiagrams FormatConditions
index	An expression that specifies the position of a member of the collection referred to by the object argument. If a numeric expression, the index argument must be a number from 0 to the value of the collection's Count property minus 1. If a string expression, the index argument must be the name of a member of the collection.

Setting

Description

object

One of the following collections:

Controls

AccessObjectProperties

DataAccessPages

AllForms

AllReports

AllDataAccessPages

AllStoredProcedures

AllDatabaseDiagrams

FormatConditions

index

An expression that specifies the position of a member of the collection referred to by the object argument. If a numeric expression, the index argument must be a number from 0 to the value of the collection's Count property minus 1. If a string expression, the index argument must be the name of a member of the collection.

The Item property is available only by using Visual Basic and is read-only.

Remarks

If the value provided for the index argument doesn't match any existing member of the collection, an error occurs.

The Item property is the default member of a collection, so you don't have to specify it explicitly. For example, the following two lines of code are equivalent:

Debug.Print Modules(0)

Debug.Print Modules.Item(0)