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 | |
|
|
|
|
||