Define the data display format for a field in table Design view

1. Open a table in Design view.
   
   
2. In the upper portion of the window, click the field you want to format.
   
   
3. In the lower portion of the window on the General tab, click the arrow next to the Format property box, and then click one of the predefined formats. If the predefined formats don't suit your needs, you can type a custom format in the Format property box for any field data type other than OLE Object. For information on how to define a custom format, click .

Note   To ensure consistency among applications, Microsoft Access uses the regional settings that are specified by double-clicking Regional Settings in the Windows Control Panel for some predefined Number and Date/Time formats. For more information, click .