Lesson 3	Working with Option Groups
Objective	Use the Option Group Wizard to create an Option Group Control.

Use the Option Group Wizard to create an Option Group Control

You can use the "Option Group Wizard" to create an Option Group Control in Microsoft Access 365. The Option Group Wizard simplifies the process of creating an option group by guiding you through a series of steps to set up the control and its options.
Here’s how to do it:
Steps to Create an Option Group Control Using the Option Group Wizard:

Open Your Form in Design View:
- Go to the Navigation Pane, right-click the form where you want the option group, and select Design View.
Access the Controls Section:
- On the ribbon, click the Design tab, then look for the Controls group.
Select the Option Group Tool:
- Click the Option Group button (it looks like a square with toggle buttons).
Draw the Option Group on the Form:
- Click and drag on the form to draw where you want the option group to appear. Once you release the mouse button, the Option Group Wizard should launch automatically.
Configure the Option Group Using the Wizard:
- Step 1: Enter the labels for the options you want to include in the group (e.g., "Option 1," "Option 2").
- Step 2: Assign values to each option. These values will be stored in the bound field when the corresponding option is selected.
- Step 3: Choose a default option, if any.
- Step 4: Decide whether to save the selected value in a field (bind it to a field) or use it unbound.
- Step 5: Select the appearance of the option buttons or checkboxes.
Finalize the Option Group:
- Once you complete the wizard, Access will create the option group control with the specified options.
Test the Option Group:
- Switch to Form View to test the functionality of your new option group.

Additional Notes:

If the wizard does not appear, make sure Use Control Wizards is enabled in the Design tab before creating the option group.
The option group control can be bound to a field in a table or query, storing the selected value.

Option Group Control

When you have a few options to choose from and want to display them all on the form, you can do so by using an Option Group control

Option Group control

Controls used with the Option Group control The Option Group control can work with one of three controls:
1. Toggle button | : This control will move you between the choices you make from the option group, with the option chosen suppressed:
2. Option button | : Also known as a radio button, this presents a round button, with the center filled in when an option is chosen.
3. Checkbox | : Just as it sounds, a checkmark is placed in the option chosen.
All these controls are found in the Form and Report Design toolboxes. They can be used with the Option Group control and by themselves as well.

Using the wizard

Although you can add an Option Group control by simply dragging it from the toolbox, it is a good idea to let the Option Group Wizard walk you through. The way to get to this wizard is to insert an Option Group control on a form, with the Wizards button

Wizards button

toggled to On.

Option Group and Option Button

The option group is a rectangular container that holds one or more option buttons. The form user can select just one of these option buttons at a time.
This is another way of displaying information and letting the user pick from a specific group of data. Using a combo box or list box gives more flexibility, however, because you would have to modify the Option Group control to add another choice, and with combo boxes you just add the choice to the row source. In the next lesson, you will learn how to create a Subform control to display data from a related table.

Option Group Controls - Quiz

Click the Quiz link below to answer a few questions about working with Combo Box and List Box controls, as well as Option Group controls.
Option Group Controls-Quiz