Microsoft Access Field Properties – Format

Format

Field properties are where you fine tune the table. The data type provides general

information about the type of data that a field is going to contain and in the properties is

where you define it more exactly.

Format controls how the data appears in tables, forms and reports (it is the default appearance in forms and reports – it can be changed in them).
The formatting options are different depending on what the data type of the field is.  For text fields the options are:

To display the whole field in upper case.
<   To display  the whole field in lower case.
If no entry is made then the data is displayed as entered.


For number and date/time data types you can choose from a standard list of displays (which meet most requirements) or customise the formatting.