Field Property

Decimal Places

Specify the number of decimal places to use when displaying numbers.

Precision

Specify the total number of digits allowed, including those both to the right of the decimal separator (when decimal field size property is set using Number data type).

IME Sentence Mode

Specify the type of data you can enter by using an Input Method Editor.

Indexed

Speed up access to data in this field by creating and using an index.

Validation Rule

Supply an expression that must be true whenever you add or change the value in this field.

Allow Zero Length

Allow entry (by setting to Yes) of zero-length string ("'') in a Short Text, Long Text, or Hyperlink field.

Default value

Automatically assign a default value to field when new records are added.

Text Format

Choose Rich Text to store text as HTML and allow rich formatting. Choosing Plain text to store only text.

Unicode compression

Compress text stored in this field when a large amount of text is stored.

Format

Customize the way the field appears when displayed or printed.

Input mask

Display editing characters to guide data entry.

Validation Text

Enter text that appears when a value violates the validation rule.

Required

Require that data be entered in a field.

Append Only

Retain a history of all data changes (by setting to Yes) of a Long Tet field.

Field size

Set the maximum size for data stored as a short text, number, or autoNumber data type.

Caption

Set the text displayed by default as the column name in tables and labels for forms, reports, and queries.

New Values

Set whether an Autonumber field is incremented or assigned a random number.

IME Mode

Specify an Input Method Editor, a tool for using English versions of windows.

Result type

Specify the data type to be used to store the value generated by the expression field property for the calculated data type.

Text align

Specify the default alignment of text within a field or control.

Expression

Specify the expression used for the Calculated data type to generate value.

Scale

Specify the maximum number of digits that can be stored to the right of the decimal separator (when decimal Field Size property is set using Number Data type).