Fields Collection Methods 

Method Name

Parameters

Return Type

Description

Add

FieldName

Variant

IField

Creates and returns a Field object to the collection if successful. Initializes the value of the field to the FieldValue parameter.

If the FieldValue is omitted, returns a Field object without a value.

If both parameters are omitted, returns an unnamed, empty Field object.

FieldValue

Variant

Item

Index

Variant

IField

Returns a Field object from the collection. The Index parameter is required and can be either a field name or an index in the collection. The Item method is the default member for the Fields collection object.

Remove

Index

Variant

Boolean

Removes a single Field object from the collection. The Index parameter is required and can be either a field name or an index in the collection. Any references to the removed Field object are invalid.