MS Access Option Group Multiple Selection Example

This tutorial will explain about MS Access Option Group and how to create it. Option Group or sometimes called Radio Button is the UI controls to provide quick, intuitive way to select from two or more mutually exclusive data values, for example is Yes or No, or Female or Male in Gender. It provide neater interface than drop down menu.
Radio buttons are called as Option Group because selecting one button automatically De-selects the other button (or other buttons) in the same group, meaning that it can only have one value. In Access, Option Group only can be used in Forms, and sometimes in Reports.

#1 Bounded Option Group
Bounded means that the option buttons bound to a field with either a number data type or a “Yes/No” data type. For this example, we use the Gender field from Member database.
1. In Table Design, create a new field with Yes/No Data Type. Save the table.

Ms Access Option Group (1)

Ms Access Option Group (1)

2. Create a new blank Form or use existing Member Form. Switch the view to Design View.
3. On Design tab > Controls group > click Option Group. Then drag to the layout to create one.

Ms Access Option Group (2)

Ms Access Option Group (2)

4. On Option Group Wizard, input the label names. Because it is bounded with Yes/No Data Type, input only 2 names. Click Next.
5. Select the default value, hit Next.
6. Assign the value for the label. Yes/No Data Type only have 0 (equivalent to No) and -1 (Yes value) values. Hit Next

Ms Access Option Group (3)

Ms Access Option Group (3)

7. Choose “Store value in this field”. Select the desired field from the combo box. Click Next.

Ms Access Option Group (4)

Ms Access Option Group (4)

8. Choose control type: Options (only one value), Checkbox (choose one or many value), or Toggle (like options, differ in interface). Then, select the Design style. Hit Next.
9. Rename the Options Caption. Click Finished.

Ms Access Option Group (5)

Ms Access Option Group (5)

 

Read Also:  Ms Access Query Examples on Expression Syntax Functions

#2 Unbounded Option Group
Bounded Option Group has limitation only for 2 values, and it would not show the value other than Yes/No. On Gender example above, when we retrieved the data to tables or report, it will still show Yes/No. Unbounded Option Group surpasses those limitation. The steps is almost same through.
1. On Option Group Wizard, input the labels.
2. Select default choice. Assign the values in number.
3. Choose “Save the Value for later use”.

Ms Access Option Group (6)

Ms Access Option Group (6)

4. Define the design and rename the captions.
5. Select the Option Group, press F4 to open Properties Sheet.
6. On Event > After Update, click the builder. Choose Code Builder.
7. Input following code, then save.

Ms Access Option Group (7)

Ms Access Option Group (7)

8. Back to Access, On Property Sheet change the Selection Type to Form.
9. On Event > On Current, click the builder, select Code Builder then input the code:

Ms Access Option Group (8)

Ms Access Option Group (8)

10. Save and test your options.

Related Access Database

  • access database radio button group
  • access db optiongroup
  • access option buttons group
  • access option group
  • ms access option group one choice
  • ms access option group vba
  • ms access radio buttons with more than one option
  • option button multiple selection Access vba
  • option group access example
Read Also:  Syntax for Ms Access Array Function


Access Database Tags: #access 2016 option group #ms access option group example #ms access option group multiple selection #ms access option group not working #ms access radio button group vba #option group wizard access 2013

MS Access VBA Close Workbook and Form
MS Access VBA Close Workbook and Form
In this tutorial, we use Ms Access
MS Access DB and MDB Viewer Software
MS Access DB and MDB Viewer Software
Access DB Viewer is the software to
MS Access Validation Rule Lookup Table Examples
MS Access Validation Rule Lookup Table Examples
The Validation Rule in Microsoft Access is


Must read×

Top