4

I've never liked the default font that is used as for datasheet views in MS Access. Recently, I've upgraded from 2003 to 2010, and for the life of me I can not find out how (via Google or otherwise) to change the default font that is used for displaying data in tables or queries.

I'm not looking for a way to set the font on a form. I want to change the default font that is used to display any data, in datasheet view.

FYI, I assume this may involve registry hack and I wouldn't mind that approach. Does anyone know if this setting can be changed?

RLH
  • 4,665

3 Answers3

5

Open RegEdit and go to this location:

HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Access\Settings

I added a new string value named "Default Font Name" (without the quotes) and entered a value of "Arial" (no quotes). No re-boot is needed.

Open any existing Access file and the font will be changed in the datasheet view. Note: If you already have access running then close and re-open Access.

slhck
  • 235,242
CHarmon
  • 487
2

Open a form or report in design view so you can get access to the Themes tab. Change the Fonts setting to your choice of fonts. This will change the default font for not only reports and forms but also datasheet views (queries or tables).

KHG
  • 21
-2

On the ribbon, click Home. On the sixth tab, labelled Text Formatting, the first box has the font name and font size.

Change this and everything resizes in the datasheet view.

slhck
  • 235,242
myfirsttip
  • 1