1.7 Fields Collection

Contains all the Field objects of a Recordset object.

1.7.1 Count property

Indicates the number of objects in a collection.

Syntax

object.Count

Type

Long.

Attributes

Read-only.

1.7.2 Item method

Returns a specific member of the Fields collection by name or ordinal number.

Syntax

object.Item(
   Index As Variant)

Parameters

Index

Either the name of the Field object you want to retrieve or the object’s ordinal position (index) in the collection.

Return Values

Field. Returns a reference to a Parameter object.