This interactive demo was created free with Storylane in 8 minutes. Create your own demo
How to Add Option Group MS Access
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.
