When you’re looking to customize an Access form, view, or report, the most common task is to add or modify controls. These are the text boxes, buttons, combo boxes, and other tools you use to add, edit, and display the data.
Whether you’re working in an app or a desktop database, you can add controls in one of two ways:
- To create an unbound control, click a control on the Design tab of the ribbon. In a web app, the control appears on the view immediately. In a desktop database, you’ll need to click on the form, view, or report where you want to place the control.
If you want, you can convert an unbound control to a bound control by editing the properties for the control. Press F4 to see the properties, then select a field name from the Control Source drop-down.
How do I choose between bound and unbound?
Bound controls are the ones that you use to view or work with data in your tables or queries. Since they’re connected to the underlying data source, any changes you make in bound controls are reflected in the data source (assuming your data source is editable).
Unbound controls are useful for displaying calculated values or for entering values that don’t need to be stored in tables. For example, you might put unbound controls on a form to enter start and end dates, then use a macro attached to a command button to read the dates and display a report for the date range entered. Since you don’t need to store those dates for future reference, the controls don’t need to be bound to anything.
What else can I do with controls?
The most common type of control is the text box; these can display many different types of data, such as text, numbers, and dates. Other controls have more specialized functions. For example, there’s a control to insert a page break into a report, one to add web content to a form, and another one to add a subform to a form. You can create a control that references a control on another form, and in a desktop database, you can change the tab order for controls.
For more about adding controls to reports, see Introduction to reports in Access.