Field properties are set in Design View. A text field is limited to a specific number of characters. Number Formats General Displays a number the way it was entered. This is the default. Currency Uses a comma as a thousands separator and displays the currency symbol.
Negative numbers display in parentheses and the default is two places.
Fixed Displays at least one digit. Default number is 2 decimal places. Standard Uses a comma as a thousands separator and the default number is two decimal places. Only a date or time is displayed. The default value is automatically entered in the field when you crate a new record.