Chapter 8: Working with Data on Access Forms
315
visible. Drag fields from the Field List to the form’s surface to add bound controls to the form.
Select and drag them one at a time, or select multiple fields by using the Ctrl key or Shift key. The
Field List in Layout view works the same as the Field List in Design view, which is described in
detail in Chapter 7.
Click the Add Existing Fields command in the Design tab’s Controls group to display the Field
List. By default, the Field List appears docked on the right of the Access window, shown in Figure
8.15. This window is movable and resizable and displays a vertical scrollbar if it contains more
fields than can fit in the window.
Access adds a control that’s appropriate for the data type of the bound field. For example, dragging
a text field to the form’s surface adds a text box, while an OLE data field adds a Bound OLE Object
control.
To add fields from the Field List to a new form, follow these steps:
- Select tblProducts in the Navigation Pane.
- Click the Create tab on the ribbon, and then select the Blank Form command
in the Form group to open a new form in Layout view. The new form is bound to
tblProducts.
- If the Field List isn’t displayed, click on the ribbon’s Design tab, and then select Add
Existing Fields from the Controls group.
- While holding down the Shift key, click the ProductID and Cost fields in the Field
List.
- Drag the selected fields to the form, as shown in Figure 8.15.
FIGURE 8.15
Adding fields from the Field List in a form’s Layout view
