Microsoft Office Tutorials and References
In Depth Information
Trouble? If the Field List pane displays the “No fields available to be added to the
current view” message, click the “Show all tables” link to display the tables in the
Panorama database, and then click the plus sign next to tblContract in the Field
List pane to display the fields in the table.
Trouble? If the tblContract table in the Field List pane is not expanded to show
the fields in the table, click the plus sign next to tblContract to display the fields.
Design view contains the tools necessary to create a custom form. You create the form
by placing controls in the blank form. You can place three kinds of controls in a form:
•A bound control is connected, or bound, to a field in the database based on the record
source, or the underlying table or query. You use bound controls to display and main-
tain table field values.
•An unbound control is not connected to a field in the database. You use unbound con-
trols to display text, such as a form title or instructions; to display lines, rectangles, and
other objects; or to display graphics and pictures created using other software
programs. An unbound control that displays text is called a label .
•A calculated control displays a value that is the result of an expression. The expression
usually contains one or more fields, and the calculated control is recalculated each
time any value in the expression changes.
To create a bound control, you add fields from the Field List pane to the Form win-
dow, and position the bound controls where you want them to appear in the form. To
place other controls in a form or a report, you use the buttons in the Controls group on
the Design tab; ScreenTips are available for each control in the Controls group. The but-
tons in the Controls group let you add to the form controls such as lines, rectangles,
images, buttons, check boxes, and list boxes.
Design view for a form contains a Detail section , which is a rectangular area consist-
ing of a grid with a section bar above the grid. You click the section bar to select the sec-
tion in preparation for setting properties for the entire section. The grid consists of the
area with dotted and solid lines that help you position controls precisely in a form. In the
Detail section, you place bound controls, unbound controls, and calculated controls for
your form. You can change the size of the Detail section by dragging its edges.
Rulers at the top and left edges of the Detail section define the horizontal and vertical
dimensions of the form and serve as guides for placing controls in a form.
Your first task is to add bound controls to the Detail section for the six fields from the
Adding Fields to a Form
When you add a bound control to a form, Access adds a text box and, to its left, an
attached label. The text box displays a field value from the record source. The attached
label displays either the Caption property value for the field, if the Caption property value
has been set, or the field name. To create a bound control, you first display the Field List
pane by clicking the Add Existing Fields button in the Tools group on the Design tab.
Then you double-click a field in the Field List pane to add the bound control to the
Detail section. You can also drag a field from the Field List pane to the Detail section.
Next, you’ll add bound controls to the Detail section for the six fields in the Field List
pane. The Field List pane displays the three tables in the Panorama database, and the six
fields in the tblContract table.