Using Display Formats


graphics/04inf04.jpg

graphics/one_icon.jpg

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).

graphics/two_icon.jpg

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.

graphics/04inf05.jpg

graphics/three_icon.jpg

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.

graphics/four_icon.jpg

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.



Easy Microsoft Office Access 2003
Easy Microsoft Office Access 2003
ISBN: 789729598
EAN: N/A
Year: 2003
Pages: 174

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net