An Option Group in Microsoft Access is a control that lets users select one choice from a group of options. Here’s how to add and configure an Option Group in an Access form:
- Open your database.
- Go to the 'Create' tab.
- Go to the 'Form Design' tab in the Ribbon.
- In the 'Controls' group, find the 'Option Group' tool.
- Click the tool, then click on the form where you want the Option Group to appear.
- Enter the labels for each option. Press 'Enter' after each label to add it to the list. Once done, click 'Next'.
- Select the default option.
- Choose a style for the Option Group.
- Choose whether you want to store a value for the selected option. Typically, you assign numeric values. Click 'Next' after.
- Add a caption for your option Group.
- You can resize the Option Group or reposition it on the form.
- By using an Option Group, you simplify the process of selecting predefined choices and ensure consistency in data entry.
