Fields Collection

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


Methods

Item, Refresh

Properties

Count

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.


© 1997 Microsoft Corporation. All rights reserved. Terms of Use.