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