Item Property (Columns Collection)

Item Property (Columns Collection)

Important  The Collaboration Data Objects (CDO) 1.2.1 Rendering objects are not installed by or supported for use with Exchange Server 2003 or later.

The Item property returns the specified Column object from the Columns collection. Read-only.

Syntax

objColumnsColl.Item(index)

objColumnsColl.Item(propTag)

index

Integer. Value must be greater than 0 and less than or equal to 65,535 (&HFFFF). Specifies the index within the Columns collection.

propTag

Long. Value must be greater than or equal to 65,536 (&H10000). Specifies the 32-bit property tag of the renderable property corresponding to a column in the collection. The renderable property is indicated in the Column objects Property property.

The Item property is the default property of a Columns collection, meaning that objColumnsColl**(index)** is syntactically equivalent to objColumnsColl.Item(index) in Microsoft® Visual Basic® code.

Data Type

Column object

Remarks

The Item property works like an accessor property.

If the specified Column object is not found in the collection, the Item property returns Nothing.

Although the Item property itself is read-only, the Column object it returns can be accessed in the normal manner, and its properties retain their respective read/write or read-only accessibility.

Example

This code fragment shows the Count and Item properties working together:

' Put all column names in a collection into a string array
Dim strItemName(100) as String
Dim i As Integer ' loop counter
' error handling omitted from this fragment ...
For i = 1 To objColumnsColl.Count
    strItemName(i) = objColumnsColl.Item(i).Name
    ' or = objColumnsColl(i) since Item and Name are default properties
    If 100 = i Then ' max size of string array
        Exit Function
    End If
Next i
 

See Also

Concepts

Columns Collection Object