ADO: ActiveX Data Objects

Name

Fields Collection — (Versions 2.0, 2.1, 2.5, 2.6)

Synopsis

Set fields = record.Fields
Set fields = recordset.Fields

See the Field object for more information and examples pertaining to the Fields collection.

Applies To

Recordset

Offers a particular view of a group of records from the associated connection.

Objects

Field

Contains information about a single field in the current record of an open Recordset object.

Methods

Append

Adds a new Field object to the collection.

CancelUpdate

Cancels any pending changes to the individual Field objects of the Record object’s Fields collection.

Delete

Removes a Field object from the current Fields collection.

Refresh

Does not perform any visible function according to the Microsoft documentation.

Resync

Updates the current collection based upon the underlying database.

Update

Persists any changes made to the current Fields collection of a Record object.

Properties

Count

Indicates how many Field objects belong to the associated Fields collection.

Item

Accesses a particular Field object belonging to the Fields collection.