Microsoft Access 2010 Bible

Part I: Access Building Blocks

236

FIGURE 6.12

Selecting and dragging a column to change the field order

You can select and drag columns one at a time, or select multiple columns to move at the same

time. Suppose you want QtyInStock to appear before Description in the tblProducts

datasheet. Follow these steps to make this change:

1. Position the mouse pointer over the QtyInStock column heading.

The cursor changes to a down arrow.

2. Click to select the column.

The entire QtyInStock column is now highlighted.

3. Release the mouse button.


4. Click the mouse button on the column heading again.

The pointer changes to an arrow with a box under it.

5. Drag the column to the left edge of the datasheet between the Description and Features
   fields.

A thin black column appears between them (see Figure 6.12).

6. Release the mouse button.

The column moves in front of the Description field of the datasheet.

With this method, you can move any individual field or contiguous field selection. To select multi-

ple fields, click and drag the mouse across multiple column headings. Then you can move the

fields left or right or past the right or left boundary of the window.

Note
Moving fields in a datasheet does not affect the field order in the table design.