The Field Properties

The Field Properties

After creating field name and data type, you can add description for each field in your table. This is optional, but it helps your table for easy understanding. It provides formatting options you can set. The options changes depend on their respective field type.

• Field Size it limits the text fields to a specific number of characters; Number fields to a specific range of values.

• Format it assigns a specific display format to Text and Date/Time fields such as:

02/24/91 or Friday, February 24, 1991

• Decimal Places it sets the number of decimal places displayed in Number and Currency like 5.75

• Input Mask specifies formatting characters like dashes in phone-number field

• Caption it supplies a label to be used in forms and reports instead of the field name.

• Validation Rule specifies a rule that will validate entries I a field

• Validation Text displays the message in relation to the validation of rule.