Access 2016 Intermediate

Access 2016

Lesson 11 – Using Advanced Form Design

Steps

Practice Data

16. Select the desired style option.

Click

Raised

The desired style option is selected and a preview appears in the Sample box.

17. Select Next .

Click

The next page of the Option Group Wizard appears with the insertion point in the What caption do you want for the option group? box.

18. Type the caption for the option group. The text appears in the What caption do you want for the option group? box.

Type Customer Type

19. Select Finish .

Click

The Option Group Wizard closes and the option group appears on the form.

Click the Note text box and use the [Down] arrow to move the Note field down to remove the overlap with the option group. Click in a blank area of the form to deselect the option group.

Switch to Form view to test the option group. Scroll to record 3 and select the Large metro markets option. Switch back to Design view.

A DDING A L OGIC C ONTROL



Discussion

Some tables contain fields that have a Yes/No field type. These fields can contain a Yes (True) value, a No (False) value, or no value at all.

When working with a form that contains a Yes/No field, you can create a logic control that is bound to the Yes/No field. Logic controls give a visual display of the value in a Yes/No field, such as a check box where a check mark appears when the field value is Yes and does not appear when the value is No . Another type of logic control is the toggle button, which appears “sunken” for a value of Yes and “raised”

OFFICEPRO, Inc.

Page 209