Inherited Access Table and Field Properties:

Access Table/Field Property

Notes

Filter

Table property.

Order By

Table property.

Sub-Datasheet Name

Table property. Supported by Access 2000/2.

Link Child Fields

Table property. Supported by Access 2000/2.

Link Master Fields

Table property. Supported by Access 2000/2.

Sub-Datasheet Height

Table property. Supported by Access 2000/2.

Sub-Datasheet Expanded

Table property. Supported by Access 2000/2.

Default View

Table property. Access 2002 only.

Orientation

Table property. Access 2002 only.

IME Sentence Mode

Field property. Access 2002 only.

Bound Column

Lookup field property when Display Control is a Combo or List Box.

Column Count

Lookup field property when Display Control is a Combo or List Box.

Column Heads

Lookup field property when Display Control is a Combo or List Box.

Column Widths

Lookup field property when Display Control is a Combo or List Box.

List Rows

Lookup field property when Display Control is a Combo Box.

List Width

Lookup field property when Display Control is a Combo Box.

Limit To List

Lookup field property when Display Control is a Combo Box.

Default Value

Not filled in, but implemented in the Scriptoria table description or triggers.

Validation Rule

Not filled in, but implemented in the Scriptoria table description CHECK constraint or by triggers.

Validation Text

Not filled in but the CHECK constraint is implemented using triggers.

Required

Not filled in, but implemented in the Scriptoria table description or in “default” triggers.

Allow Zero Length

Text and Memo property. This property is set to Yes by Jet on linked DB2 tables.

Indexed

Set by Access when an Index has been defined.