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.