Field
Action
Field Size
Specify the maximum number of characters (up to 255) that can be entered in the field.
Format
Specify how the data for the field will appear on the screen.
Input Mask
Specify a format or pattern in which data must be entered.
Caption
Enter a label for the field when used on a form. If you don't enter a caption, Access uses the field name as the label.
Default Value
Specify a value that Access enters automatically.
Validation Rule
Enter an expression that limits the values that can be entered in this field.
Validation Text
Enter an error message that appears when a value prohibited by the validation rule is entered.
Required
Indicate whether data entry is required.
Allow Zero Length
Specify if field allows zero length text strings.
Indexed
Indicate whether Access will keep an index of field values.
Unicode Compression
Indicate whether you want Access to save space if only plain text is entered.
