Fields Collection

A Fields collection contains all stored Field objects of a Recordset object.

Properties

Count, Item

Methods

Refresh

Remarks

A Recordset object has a Fields collection made up of Field objects. Each Field object corresponds to a column in the Recordset.

To refer to a Field object in a collection by its ordinal number or by its Name property setting, use any of the following syntax forms:

recordset.Fields.Item(0)
recordset.Fields.Item("name")
recordset.Fields(0)
recordset.Fields("name")
recordset(0)
recordset("name")
recordset![name]

Note See the Field object topic for a more detailed explanation of how to use Field objects.

Applies To

Recordset

See Also

Field