Microsoft Access 2010 Bible

Chapter 6: Working with Datasheet View

239

Changing display fonts

By default, Access displays all data in the datasheet in the Calibri 11-point Regular font. Use the

commands and drop-down lists in the ribbon’s Text Formatting group (shown in Figure 6.15) to

change the datasheet’s text appearance.

FIGURE 6.15

Changing the datasheet’s font directly from the ribbon. Choose font type style, size, and other font attri-
butes for the entire datasheet.

Font type face Font name Font size

Font color

Background color

Grid lines

Numbering

Bullets

Setting the font display affects the entire datasheet. If you want to see more data on the screen, you

can use a very small font. You can also switch to a higher-resolution display size if you have the

necessary hardware. If you want to see larger characters, you can increase the font size or click the

Bold button.

Displaying cell gridlines and alternate row colors

Normally gridlines appear between fields (columns) and between records (rows). You can set how

you want the gridlines to appear using the Gridlines command in the ribbon’s Text Formatting

group (shown in Figure 6.15). Choose from the following options in the Gridlines drop-down list:

l Gridlines: Both

l (^) Gridlines: Horizontal
l Gridlines: Vertical
l (^) Gridlines: None
Use the Fill Color and Alternate Fill/Back Color drop-down lists to change the background colors
of the datasheet. The Fill Color palette changes the color of the odd-numbered rows in the data-
sheet. The Alternate Fill/Back Color palette changes the color of the even-numbered rows. If you
don’t want alternating row colors, select No Color from the Alternate Fill/Back Color palette and
the even-numbered rows will match the odd-numbered rows.