Create a check box, toggle button, or option button

How you create a check box, option button, or toggle button depends on whether you want it to be a bound (bound control: A control used on a form, report, or data access page to display or modify data from a table, query, or SQL statement. The control's ControlSource property stores the field name to which the control is bound.) control or an unbound (unbound control: A control that is not connected to a field in an underlying table, query, or SQL statement. An unbound control is often used to display informational text or decorative pictures.) control. To create a bound control, you must be working in a form or report that is bound to a record source (record source: The underlying source of data for a form, report, or data access page. In an Access database, it could be a table, query, or SQL statement. In an Access project, it could be a table, view, SQL statement, or stored procedure.), or in a data access page (data access page: A Web page, published from Access, that has a connection to a database. In a data access page, you can view, add to, edit, and manipulate the data stored in the database. A page can also include data from other sources, such as Excel.) that is connected to a database. In a Microsoft Access database (Microsoft Access database: A collection of data and objects (such as tables, queries, or forms) that is related to a particular topic or purpose.), you can create a control that is bound to a Yes/No field; in a Microsoft Access project (Microsoft Access project: An Access file that connects to a Microsoft SQL Server database and is used to create client/server applications. A project file doesn't contain any data or data-definition-based objects, such as tables and views.), you can create a create a control that is bound to a Bit column.

ShowCreate a bound check box, toggle button, or option button

  1. Open a form, report, or data access page in Design view (Design view: A view that shows the design of these database objects: tables, queries, forms, reports, and macros. In Design view, you can create new database objects and modify the design of existing objects.).
  2. Click the appropriate tool in the toolbox (toolbox: A set of tools that is available in Design view for adding controls to a form or report.). If you're not sure which tool to use, place the pointer over the tool until the ToolTip (ToolTips: Brief descriptions of the names of commands and buttons on the Ribbon. A ToolTip is displayed when the mouse pointer rests on these commands and buttons.) appears.

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

  1. If the field list (field list: A window that lists all the fields in the underlying record source or database object, except in data access page Design view. In data access page Design view, it lists all the record sources and their fields in the underlying database.) isn't visible, click Field List Button image on the toolbar.
  2. Click the appropriate field in the field list, and drag it 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.

  1. Change the label text if necessary.
  2. Switch to Form view (Form view: A view that displays a form to show or accept data. Form view is the primary means of adding and modifying data in tables. You can also change the design of a form in this view.), Datasheet view (Datasheet view: A view that displays data from a table, form, query, view, or stored procedure in a row-and-column format. In Datasheet view, you can edit fields, add and delete data, and search for data.), Page view (Page view: An Access window in which you can browse the contents of a data access page. Pages have the same functionality in Page view as in Microsoft Internet Explorer 5.0 or later.), or Print Preview (print preview: A view of a document as it will appear when you print it.) to test the control.

ShowCreate an unbound check box, toggle button, or option button

  1. Open a form, report, or data access page in Design view (Design view: A view that shows the design of these database objects: tables, queries, forms, reports, and macros. In Design view, you can create new database objects and modify the design of existing objects.).
  2. Click the appropriate tool in the toolbox (toolbox: A set of tools that is available in Design view for adding controls to a form or report.). If you're not sure which tool to use, place the pointer over the tool until the ToolTip (ToolTips: Brief descriptions of the names of commands and buttons on the Ribbon. A ToolTip is displayed when the mouse pointer rests on these commands and buttons.) appears.

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

  1. On the form, report, or data access page, click where you want to place the control. If you're placing the control in an option group (option group: A frame that can contain check boxes, toggle buttons, and option buttons on a form or report. You use an option group to present alternatives from which the user can select a single option.) on a form or report, Microsoft Access highlights the option group when you move the pointer over it to show that the control will become part of the option group.
 
 
Applies to:
Access 2003