Microsoft Office Tutorials and References
In Depth Information
Taking Control of Your Form or Report
Table 2-1 (continued)
Box that contains or doesn’t contain a
Object Linking and Embedding (OLE)
or embedded object (graph, picture,
sound file, or video) that isn’t stored in
a field in a table.
Option (radio) button that’s part of an
Control that adds a subform or subreport
to the form,
OLE or embedded object (graph,
picture, sound file, or video) that’s stored
in a field in a table.
Many of these controls are bound controls, displaying values from a field,
such as the text box (for text fields), check box (for Yes/No fields), and
attachment (for Attachment fields) controls. Others are unbound controls,
like the image (for displaying an icon or picture not stored in a database
table), line, or page break. This chapter shows you how to use many of these
types of controls.
Making a new control by dragging a field
Making most forms and reports consists mainly of setting up the bound
controls to display the fields from the record source. Access makes the job easy
with a quick drag-and-drop procedure:
1. Open your form in Design view.
2. Display the field list, if it isn’t already displayed, by clicking the Add
Existing Fields button in the Tools group on the Design tab of the
3. If the fields for the table you’ve chosen aren’t displayed, click the plus
sign to the left of the table name to display them.
Figure 2-2, earlier in this chapter, shows the field list, with a list of the
fields in your table or query. If your form doesn’t have a record source,
or if the fields look like the wrong ones, see Chapter 1 of this minibook.