Change the format of data in a control

1. Open the form, report, or data access page in Design view.
2. Click the control you want to change, and then click Properties on the Form Design, Report Design, or Page Design toolbar to open its property sheet.
3. In the Format property box, do one of the following:
   • Click one of the predefined formatting settings. 
   • Type a custom format. Click the Format property box and press F1 for more information about custom formats.  

Note  To ensure consistency among applications, Microsoft Access uses the regional settings that are specified in Microsoft Windows Control Panel for some predefined Number and Date/Time formats.