Text and Memo data type field properties
Field Size - Used to vary field lengths, defaults to 50 characters.
Format - Allows you to create custom formats for your text string, i.e. '@' = text required, '&' = text is not require, '<' = forced lower case, '>' = forced upper case.
Input Masks - Used to ensure that all data entered into a field was the correct data entry pattern. Forces the user to enter values in an exact format.
Caption - A naming convention given to a field to help the end user input the relevant details.
Default Value - A self explanatory field type, automatically populating the field with a pre-defined default string.
Validation Rule - Allows you to set limits to values to maintain data integrity.
Validation Text - Used in conjunction with the Validation Rule will display a warning message if the user has not met certain validation rule criteria when populating the field.
Required - Simply a value that denotes whether a field should be populated, i.e. is or is not mandatory.
Allow Zero Length - Allows you to control the way that blank fields are handled.
Indexed - The crucial field property for expedient queries, sorting and field manipulation. Indexed fields hold all tables and relationships together.