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 ...

Get Special Edition Using Access 97, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.