Microsoft Access 2010 Bible

Part I: Access Building Blocks

238

Changing the record display height

You might need to increase the row height to accommodate larger fonts or text data displays of

multiple lines. Change the record (row) height of all rows by dragging a row’s border to make the

row height larger or smaller, or you can choose More ➪ Row Height in the ribbon’s Records group.

When you drag a record’s border, the cursor changes to the vertical two-headed arrow you see at

the left edge of Figure 6.14.

FIGURE 6.14

Changing a row’s height. Position the mouse as shown, and drag to the desired height.

To increase or decrease a row’s height, follow these steps:

1. Place the mouse pointer between record selectors of two rows.

The cursor changes to the double-pointing arrow (up and down).

2. Drag the row border upward to shrink all row heights, or drag the border downward to
   increase all row heights.

Note
The procedure for changing row height changes the row size for all rows in the datasheet. You can’t have rows
with different heights.

You can also resize rows by choosing More ➪ Row Height in the ribbon’s Records group. The Row

Height dialog box appears; there you enter the row height in point size. Check the Standard Height

check box to return the rows to their default size.

Caution
If you drag a record’s gridline up to meet the gridline immediately above it in the previous record, all rows are
hidden. This also occurs if you set the row height close to 0 (for example, a height of 0.1) in the Row Height
dialog box. In that case, you must use the Row Height dialog box to set the row height to a larger number to
redisplay the rows.