Create an option group with a wizard on a form or report

Create an option group with a wizard on a form or report

For best results in a Microsoft Access database, create option groups only for fields whose data type is Number (and whose FieldSize property is set to Integer or Long Integer) or Yes/No. In a Microsoft Access project, create option groups only for columns whose data type is Int, SmallInt, TinyInt, and Bit. For fields or columns with other data types, use a list box, drop-down list box, or combo box.

  1. Open a form in Design view or a report in Design view.

  2. Click the Control Wizards tool in the toolbox if it's not already pressed in.

  3. In the toolbox, click the Option Group tool .

  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.