Microsoft Access 2010 Bible

Chapter 7: Creating Basic Access Forms

271

Note
As you add controls from the Field List, Access builds the form’s RecordSource property as a SQL statement.
The RecordSource after adding these four fields is

SELECT tblProducts.Model, tblProducts.Description, tblProducts.Category,

tblProducts.RetailPrice, tblProducts.Cost FROM tblProducts;

Selecting and deselecting controls

After you add a control to a form, you can resize it, move it, or copy it. The first step is to select

one or more controls. Depending on its size, a selected control might show from four to eight han-

dles (small squares called moving and sizing handles) around the control — at the corners and mid-

way along the sides. The move handle in the upper-left corner is larger than the other handles and

you use it to move the control. You use the other handles to size the control. Figure 7.17 displays

some selected controls and their moving and sizing handles.

FIGURE 7.17

A conceptual view of selecting controls and their moving and sizing handles

Moving handle

Sizing handles

The Select command (which looks like an arrow) in the Controls group must be chosen in order

for you to select a control. If you use the Controls group to create a single control, Access automat-

ically reselects the pointer as the default.