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

1. Open a query in Design view.
   
   
2. In the query design grid, place the insertion point in the column for the field you want to format. You can place the insertion point in any row for that field.
   
   
3. Click Properties on the toolbar to open the property sheet for that field.
   
   
4. 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 Windows Control Panel for some predefined number and date/time formats. For more information, click .