Microsoft Access 2010 Bible

Part I: Access Building Blocks

240

After changing the gridline settings or alternate row colors, Access will ask whether to save the

changes to the datasheet’s layout. Be sure to click the Yes button to make the changes permanent.

The Datasheet Formatting dialog box (shown in Figure 6.16) gives you complete control over the

datasheet’s look. Open this dialog box using the Datasheet Formatting command in the bottom-

right corner of the ribbon’s Text Formatting group. Use the Flat, Sunken, and Raised radio buttons

under Cell Effect to change the grid to a 3-D look. Click the Horizontal and Vertical check boxes

under Gridlines Shown to toggle which gridlines you want to see. Change the Background Color,

Alternate Background Color, and Gridline Color using the available color palettes. The sample in

the middle of the dialog box shows you a preview of changes.

FIGURE 6.16

The Datasheet Formatting dialog box. Use this dialog box to customize the look of the datasheet.

Use the Border and Line Styles drop-down lists to change the look of the gridlines. You can change

the styles for the Datasheet Border and the Column Header Underline. Choose a different line style

for each of the selections in the first drop-down list. The different line styles you can select from

include

l (^) Dash-Dot
l Dash-Dot-Dot
l (^) Dashes
l Dots
l (^) Double Solid
l Short Dashes
l (^) Solid
l Sparse Dots
l (^) Transparent Border