Access lets you choose how to display the contents of data in your tables. For example, you can display the field’s contents in all uppercase or lowercase letters, change the color of the text, or display characters in addition to the data entered into the field. For example, if a product is only available by the case, adding the word "cases" after the number would remove any confusion as to the quantity being ordered. Adding formatting instructions only changes how data is displayed—it doesn’t affect the data itself.
Open a table in Design view.
Click the name of the field to format.
Type the formatting ...