Microsoft Office Tutorials and References
In Depth Information
Suggestions for Creating a Form Productively
To design a form productively, you should keep in mind the following suggestions:
• You can click the Undo button one or more times immediately after you make one or more
errors or make undesired form adjustments.
• You should back up your database frequently, especially before you create new objects or
customize existing objects. If you run into difficulty, you can revert to your most recent
backup copy of the database.
• You should save your form after you’ve completed a portion of your work successfully and
before you need to perform steps you’ve never done before. If you’re not satisfied with
subsequent steps, close the form without saving the changes you made since your last
save, and then open the form and perform the steps again.
• You can always close the form, make a copy of the form in the Navigation Pane, and prac-
tice with the copy.
• Adding controls, setting properties, and performing other tasks in Access in the correct
way should work all the time with consistent results, but in rare instances, you might find
a feature doesn’t work properly. If a feature you’ve used succesfully doesn’t work sud-
denly, you should save your work, close the database, make a backup copy of the data-
base, open the database, and then compact and repair the database. Performing a
compact and repair resolves most of these types of problems.
Compare your form’s Detail section with Sarah’s design, and notice that you need to
move the ContractType bound control up and to the right. To do so, you must select and
move the bound control.
Selecting, Moving, and Aligning Controls
Six text boxes now appear in the form’s Detail section, one below the other. Each text
box is a bound control connected to a field in the underlying table. Each text box has an
attached label to its left. Each text box and attached label pair is a control in the form,
and each individual text box is also a control in the form, as is each individual label.
When you select a control, the control becomes outlined in orange, and eight squares,
called handles, appear on its four corners and at the midpoints of its four edges. The
larger handle in a control’s upper-left corner is its move handle , which you use to move
the control. You use the other seven handles, called sizing handles , to resize the control.
When you work in Design view, controls you place in the form do not become part of a
control layout, so you can individually select, move, resize, and otherwise manipulate
one control without also changing the other controls. However, at any time you can
select a group of controls and place them in a control layout—either a stacked layout or
a tabular layout.