Changing the Font and Font Size

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:

  1. From the Format menu, choose Font . The Font dialog box appears (see Figure 8.4).

    Figure 8.4. Select the different font options in the Font dialog box.


  2. Select a font from the Font list box.

  3. Select a style from the Font Style list box.

  4. Select a size from the Size list box.

  5. Select a color from the Color drop-down list.

  6. (Optional) Click the Underline check box if you want underlined text.

  7. You can see a sample of your changes in the Sample area. When you're happy with the look of the sample text, click OK .

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.

Microsoft Office 2003 All-in-One
Microsoft Office 2003 All-in-One
Year: 2002
Pages: 660
Authors: Joe Habraken

Similar book on Amazon © 2008-2017.
If you may any questions please contact us: