Access 2016 Intermediate

Lesson 1 – Setting Field Properties

Access 2016

Selecting a Display Control property

NOTE If no format is set, an entry of Yes , True , or On displays a field value of -1 , and an entry of No , False , or Off displays a field value of 0 .



Procedures

1. Open the desired table in Design view. 2. Select the field for which you want to set a yes/no 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 yes/no format. 7. Select the Lookup tab. 8. Select the Display Control list. 9. Select the desired yes/no control.



Step-by-Step

Set a yes/no format.

Page 12

OFFICEPRO, Inc.