How To Formatting a Datasheet in Access 2003

If you want to print a datasheet, you can use formatting tools to make it look better than the standard display. You can apply special effects to cells, change the background and gridline color, and modify border and line styles. If you don't want to show the gridlines, you can hide either the horizontal or vertical gridlines, or both. The default display for a datasheet is to display the columns from left to right. If you prefer, you can change the column display to appear from right to left.

Format a Datasheet

Open the datasheet you want to format.

Click the Format menu, and then click Datasheet.

Click a cell effect option.

Select or clear the Horizontal or Vertical check box to show or hide gridlines.

Click the Background Color or Gridline Color list arrow, and then select a color.

Click the Border And Line Styles list arrow, and then select the styles you want.

Click a display direction option.

Click OK.

Did You Know? You can change the font and font style in a datasheet. Open the datasheet you want to format, click the Format menu, click Font, select the font and style settings you want, and then click OK.