Create an option group

Microsoft Office Access 2003

previous page next page
  1. Open a form or report in Design view.
  2. Click the Control Wizards tool Button image in the toolbox if it's not already selected.
  3. In the toolbox, click the Option Group tool Button image.
  4. On the form or report, click where you want to place the upper-left corner of the option group.
  5. Follow the directions in the wizard dialog boxes. In the last dialog box, click Finish to display the option group in Design view.

ShowCreate an option group on my own

  1. Open a form, report, or data access page in Design view.
  2. Click the Control Wizards tool Button image in the toolbox if it's selected. This turns off the wizard.
  3. In the toolbox, click the Option Group tool Button image.
  4. Do one of the following:

    To create an unbound option group, click where you want to place the group frame.

    To create a bound option group, click Field List Button image on the toolbar to display the field list, and then drag the appropriate field or column from the field list to the form, report, or data access page.

    Note  The control won't be bound if you try to create it by clicking the form, report, or data access page instead of dragging the selected field from the field list.

  5. In the form or report toolbox, click the Check Box Button image, Option Button Button image, or the Toggle Button tool Button image. In the data access page toolbox, click the Option Button Button image tool.
  6. Click inside the group frame where you want the upper-left corner of the check box, option button, or toggle button to appear.

  7. Do one of the following:

    On a form or report, if necessary, click the control, click Properties Button image on the toolbar, and then change the OptionValue property to the value that you want the option group to have when you click that control. When you add the first control to an option group on a form or report, Microsoft Access sets its OptionValue property to 1.

    On a data access page, click the option button, click Properties Button image on the toolbar, and then change the Value property from on to the value that you want the option group to have when you click that button.

    If the option group is bound, the value of the control's OptionValue or Value property is the value that Microsoft Access stores in the underlying table when you click that control.

    Selected option in an option group

    Callout 1 OptionValue or Value property set to 1 - clicking this button sets the value of the Ship Via option group to 1 and, if the option group is bound, stores that value in the underlying table.

    Callout 2 OptionValue or Value property set to 2 - clicking this button sets the value of the Ship Via option group to 2 and, if the option group is bound, stores that value in the underlying table.

    Callout 3 OptionValue or Value property set to 3 - clicking this button sets the value of the Ship Via option group to 3 and, if the option group is bound, stores that value in the underlying table.

  8. Repeat steps 5 through 7 for each control you add to the option group. On a form or report, Access sets the OptionValue property of the second control to 2, the third to 3, and so on.

ShowTip

To facilitate data entry, you can make the most commonly chosen option the default by setting the DefaultValue property of the option group.

previous page start next page