Create a check box, toggle button, or option button that's bound to data

Create a check box, toggle button, or option button that's bound to data

  1. Open a form in Design view, a report in Design view, or a data access page in Design view.

  2. Click the appropriate tool in the toolbox. If you're not sure which tool to use, place the pointer over the tool until the ToolTip appears.

    Note   The toggle button is not available in data access pages.

  3. Click Field List on the toolbar. The field list appears. In a form or report, if the field list button or command isn't available, you need to bind the form or report to a record source. In a data access page, if the field list is empty, you must connect the page to a database.

  4. Click the appropriate field (a field with a Yes/No data type in a Microsoft Access database or a column with a Bit data type in a Microsoft Access project) in the field list, and drag it to the form, report, or data access page.

    Note   You must drag the field from the field list. If you click the field in the field list and then click the form, report, or data access page, the control won't be bound.

  5. Change the label text if necessary.

  6. Switch to Form view, Datasheet view, Page view, or Print Preview to test the control.

Tip   If you often display the same Yes/No field or Bit column as a check box on different forms and reports in a database, you can set the DisplayControl property of the field so that when you drag it from the field list, it automatically creates a check box (you don't have to click the Check Box tool first). For more information, click .