After you've opened the table you want to change in Design view, click in the field whose display format you want to modify (in this example, the List Date field).
In the property sheet, click in the Format field. A down arrow appears to the right of the field.
INTRODUCTION
Access enables you to select a predesigned format for the entries in your table. For example, you can select one format to display numbers in a currency format ($19.99), or another to display numbers as a percentage (10%). You can also select a variety of date and time formats.
Click the down arrow and select the format you want to use from the list that appears. Here, date and time formats are available, because the field selected in step 1 is a Date/Time field.
The new format is selected. Click the Save button on the Standard toolbar found in the main Access window to save this change to the database table.
TIP
Changing to Design View
You can change to Design view from within Datasheet view by clicking the View button on the Standard toolbar in the main Access window.
TIP
Adding Decimal Places
For Number fields, you can set the number of decimal places displayed by typing a value in the Decimal Places field in the property sheet.
