• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL

Chapter 6. Sorting, Finding, and Filteri... > Customizing Datasheet View

Customizing Datasheet View

To customize the appearance of Datasheet view, you can hide the fields you don't want to appear in your datasheet, change the height of the record rows, eliminate the grid lines, and select a different font for your display. The following list describes each option for customizing Table and Query Datasheet view:

  • To hide a field, select it by clicking its field header or placing the caret in the column for the field. Then choose Format, Hide Columns.

  • To show a hidden field, choose Format, Unhide Columns to display the Unhide Columns dialog shown in Figure 6.28. Columns that appear in Datasheet view are indicated by a check mark next to the field name in the Column list. Click the box to the left of the field name to toggle between hiding and showing the column.

    Figure 6.28. The Unhide Columns dialog, which allows you to show and hide datasheet fields.

  • To change the font used to display and print the datasheet, use the Font drop-down list on the Formatting toolbar (if it is displayed), or choose Format, Font to display the Font dialog, shown in Figure 6.29. (The Font dialog is one of the common dialogs of Windows 95 and Windows NT 4.0. Other common dialogs include the Open and Save dialogs.)

    Figure 6.29. Choosing a display and printing font for datasheets.

  • To remove gridlines from the display and printed versions of the datasheet, use the Gridlines Shown drop-down list on the Formatting toolbar, or choose Format, Cells. If you use the Gridlines Shown drop-down list, Access displays a palette of four gridline display choices: Both, Horizontal, Vertical, and None; click the button corresponding to the gridline display you want. If you choose Format, Cells, Access displays the Cells Effects dialog, which contains check boxes for the horizontal and vertical gridlines; select or clear the check boxes for the desired gridline display.

  • To change the height of the rows as displayed and printed, position the mouse pointer at the bottom edge of one of the record selector buttons. The pointer turns into a double-headed arrow, as shown in Figure 6.30. Drag the bottom edge of the button to adjust the height of all the rows. Alternatively, choose Format, Row Height and set the height in points in the Row Height dialog. (Multiply the size of your font by about 1.25 to obtain normal row spacing; printers call 10-point type with 12-point spacing 10 on 12.)

  • To change the width of the columns to accommodate a larger font, choose Format, Column Width and then click the Best Fit button to let Access determine the size of your columns. You might need to adjust individual column widths by dragging the right edge of the field header with the mouse.



Not a subscriber?

Start A Free Trial

  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint