Unlike other Access views (such as Report and Form), the Datasheet view doesn't allow you to format individual fields or portions of the data that are entered in a particular view. You can format the font style only for the entire table. Font changes are automatically applied to all data in the table, including the field column headings.
Font changes that you make in Datasheet view won't affect the way your data looks in other Access objects, such as your reports , queries, or forms. They affect only the table itself.
There are some good reasons for changing the font style in a table. For example, you might want to increase the font size so that the field contents are easier to read. Or you might bold the data in the table so that you get a nice, crisp printout when you print the table.
Changing the Default Font Style
If the default style used in Access for tables has been bugging you from the beginning, you can change the default font used in Datasheet view for all the tables you create in Access.
Select Tools , and then Options . Select the Datasheet tab of the Options dialog box (see Figure 8.3).
Figure 8.3. You can change the default Datasheet font properties in the Options dialog box.
Use the different drop-down menus in the Default Font box of the Datasheet tab to select the font name , font weight, or font size. When you have finished making your changes, click OK .
Changing the Font Style for a Table
Font changes that you make to a specific table override the default font settings. To choose a different font for a currently open table datasheet, follow these steps:
Another way you can change the look of your table is with the Datasheet Formatting dialog box (choose Format , Datasheet ). You can change the cell special effects, background color, the color of the grid lines between each row and column, and whether the lines show.