ADO: ActiveX Data Objects

Name

Record.Fields Collection — (Versions 2.5, 2.6)

Synopsis

record.Fields

The Fields collection contains individual Field objects for the current Record object.

Datatype

Fields (Collection object)

Description

The Fields collection contains multiple Field objects for the current Record object. There are two special Field objects, adDefaultStream and adRecordURL,that can be accessed by specifying the FieldEnum enumeration. One returns the default string for the current Record object, and the other returns the URL.

Field objects can be added to the collection either by calling the Field.Append method or by referencing a Field by name that is not already part of the collection. Calling the Field.Update method will add the field to the collection, if possible, within the data source. Until this moment, the Field.Status property will return adFieldPendingInsert.

See Also

Field.Append Method, Field.Update Method, FieldEnum Enumeration