A Fields collection contains all stored Field objects of a Recordset object.
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.