Microsoft Office Tutorials and References
In Depth Information
Getting Your Fields Lined Up in Layout View
have a second control layout to the right of the first one if it has a second
column of controls. Control layouts are invisible in Form view; you, the form
designer, can see them in Layout and Design view.
If you can’t see Layout view — if it just doesn’t appear as an option in your
menus and buttons — it may be disabled for this database. Click the File tab
of the Ribbon, choose Options to see the Access Options dialog box, and
click Current Database to see the options for this database. Make sure that
the Enable Layout View check box is selected.
Using a control layout to rearrange fields
Suppose that you followed the steps in “Making the easiest possible form
with the Form button,” earlier in this chapter, to create the form shown in
Figure 1-1, but you don’t like the arrangement of fields on the form. Well, we
have good news for you: You can use Layout view to make some changes.
To open a form in Layout view, right-click the form name in the Navigation
Pane and choose Layout View from the contextual menu. The form appears,
as shown in Figure 1-1, with the controls (text boxes and check boxes) and
labels (the names to the left of each control) lined up neatly in a grid. The
arrangement looks very much like a table in a word-processing document or
spreadsheet. Faint dotted lines separate the rows and columns in the grid.
When your form is in Layout view, three tabs of the Ribbon contain useful
buttons: Design, Arrange, and Format.
You can move a field to another spot on the form by clicking and dragging
its control. Access forces the field into a row and column in the control
layout; if there isn’t space for the field, Access inserts a row to make space.
The control’s label may not come along with it, so you may need to drag it to
the spot to the left of the relocated field.
Adding and deleting fields
The easiest way to add fields to an existing form is to use the field list.
Display the field list by clicking the Add Existing Fields button in the Tools
group on the Design tab of the Ribbon. Click the plus sign to the left of the
table that contains the fields you want to display on the form, so that you
see the field names. Then drag the field name from the field list to where
you want it on the form. (Another way is to click the buttons in the Controls
group on the Design tab of the Ribbon. We describe this method in Chapter
2 of this minibook.)
You can get rid of a field that you don’t want to appear on the form.
(Removing the field from the form doesn’t delete it from the table where it’s
stored; Access just doesn’t display the field on this form.) Right-click the
field control and choose Delete from the contextual menu. You may need to
delete the label or explanatory text about the field in the same way.