Access 2016 Intermediate

Lesson 1 – Setting Field Properties

Access 2016

NOTE The Format property list displays how a number will be formatted for format types other than Text and Memo . If a table has reports or forms associated with it, you may want to apply changes you make to field property settings in a particular table to the corresponding property settings, or bound controls, in the joined forms or reports. You can do this by selecting the Property Update Options button that appears next to the field when the property is changed. You can then select the Update Format everywhere < field name > is used command and then select Yes in the Update Properties dialog box to apply the settings to the bound controls.



Procedures

1. Open the desired table in Design view. 2. Select the field for which you want to set a number format. 3. Select the General tab in the Field Properties pane, if necessary. 4. Select the Format property. 5. Select the Format list. 6. Select the desired format.



Step-by-Step

Set a number format.

Display All Access Objects in the Navigation Pane. Notice the Customers table has a Customers form and a Customers report associated with it. Open the Customers report and the Customers form and notice the formatting in the Credit Limit fields. Then open the Customers table in Datasheet view and notice the formatting in the Credit Limit field. Close the Customers table.

Open the Customers table in Design view.

Page 8

OFFICEPRO, Inc.