Field Object, Fields Collection Summary

 

Field Object

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

Legend:

jetFeature available in Microsoft Jet workspaces only.

daoodbcFeature 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



check



CreateProperty

jet

jet


jet

jet

GetChunk



check



 

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.

roRead-only

rwRead/write

Property

Index

QueryDef

Recordset

Relation

TableDef

AllowZeroLength


rojet

rojet



rw jet

Attributes

ro

ro

ro



ro

CollatingOrder


rojet

rojet




DataUpdatable

ro

ro

ro

ro

ro

DefaultValue


rojet

rojet



rwjet

FieldSize



ro




ForeignName




ro


Name

ro

ro

ro

ro

rw

OrdinalPosition


ro

ro



rwjet

OriginalValue



rodaoodbc *




Required

ro

ro

ro



ro

Size


ro

ro



ro

SourceField


ro

ro



ro

SourceTable


ro

ro



ro

Type

ro

ro

ro



ro

ValidateOnSet



rwjet




ValidationRule


rojet

rojet



rw

ValidationText


rojet

rojet



rw

Value

rw


rw




VisibleValue



rodaoodbc *











 

* 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

check



check

check

Delete

check



check

check

Refresh

check

check

check

check

check

 

Property

Index

QueryDef

Recordset

Relation

TableDef

Count

check

check

check

check

check