Field Object, Fields Collection Summary

   

Field Object

A Field object contains this collection, these methods, and these properties.

Legend:

Feature available in Microsoft Jet workspaces only.

Feature available in ODBCDirect workspaces only.

Collection

Properties

Methods

The following table lists all of the Field object methods. The type of object whose Fields collection contains the Field object determines which methods are available.

Method Index QueryDef Recordset Relation TableDef
AppendChunk
CreateProperty
GetChunk

Properties

The following table lists all of the Field object properties. The type of object whose Fields collection contains the Field object determines which properties are available. All properties are read-only for Field objects appended to Fields collections of Index, Relation, and TableDef objects.

Read-only

Read/write

Property Index QueryDef Recordset Relation TableDef
AllowZeroLength
Attributes
CollatingOrder
DataUpdatable
DefaultValue
FieldSize
ForeignName
Name
OrdinalPosition
OriginalValue *
Required
Size
SourceField
SourceTable
Type
ValidateOnSet
ValidationRule
ValidationText
Value
VisibleValue *

* These properties are only available in an ODBCDirect workspace whose DefaultCursorDriver property is set to dbUseClientBatchCursor.

Fields Collection

A Fields collection appears in each of the TableDef, QueryDef, Recordset, Relation, and Index objects, and contains these methods and this property.

Method Index QueryDef Recordset Relation TableDef
Append
Delete
Refresh

Property Index QueryDef Recordset Relation TableDef
Count