Access 2016 Intermediate

Access 2016

Lesson 1 – Setting Field Properties

Steps

Practice Data

1. Select the field for which you want to set a number format. The field is selected. 2. Select the General tab in the Field Properties pane, if necessary. The General tab appears.

Scroll as necessary and click in the Credit Limit field Click the General tab, if necessary

3. Select the Format property.

Click in the Format box

A drop-down arrow appears in the Format box.

4. Select the Format list.

Click Format

A list of available formats appears.

5. Select the desired format.

Click Currency

The format appears in the Format box and the Property Update Options button appears, if appropriate.

Click the Property Update Options button next to the Format property and select the Update Format everywhere Credit Limit is used command. In the Update Properties dialog box, select Yes to update the associated form and report so that the number format setting is applied to the corresponding bound controls.

Save your changes; then, switch to Datasheet view. Scroll to the Credit Limit column. Notice that the values are now formatted as currency.

Close the Customers table. Open the Customers form and the Customers report and notice the changes to the formatting in the Credit Limit field.

S ETTING D ATE /T IME F ORMATS



Discussion

You can also change the format of a Date/Time field to change the way the date or time appears in the table. The available formats for Date/Time fields are listed in the following table:

OFFICEPRO, Inc.

Page 9