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.
- Open a form in Design view or a report in Design view.
- Click the Control Wizards tool in the toolbox if it's not already pressed in.
- In the toolbox, click the Option Group tool .
- On the form or report, click where you want to place the upper-left corner of the option group.
- Follow the directions in the wizard dialog boxes. In the last dialog box, click Finish to display the option group in Design view.