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

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

Customizing Datasheet View

To customize the appearance of the 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 gridlines, and select a different font for your display. The following list describes each option for customizing Table and Query Datasheet views:

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

  • To show a hidden field, choose Unhide Columns from the Format menu to display the Unhide Columns dialog (see Figure 6.27). A mark next to the field name in the Column list indicates columns appearing in Datasheet view. Click the box to the left of the field name to toggle between hiding and showing the column.

    Figure 6.27. 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's displayed) or choose Font from the Format menu to display the Font dialog. (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.)

  • 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 Datasheet from the Format menu. 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 use the Format menu, Access displays the Datasheet Formatting dialog, shown in Fig 6.28, which contains check boxes for the horizontal and vertical gridlines. Select or clear the check boxes for the desired gridline display.

    Figure 6.28. Formatting the datasheet.

  • 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 (see Figure 6.29). Drag the bottom edge of the button to adjust the height of all the rows. Alternatively, choose Row Height from the Format menu 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 Column Width from the Format menu and then click the Best Fit button to let Access determine the size of your columns. Double-clicking the divider You might need to adjust individual column widths by dragging the right edge of the field header with the mouse.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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