Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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?

share|improve this question

2 Answers 2

up vote 1 down vote accepted

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.

share|improve this answer
    
This isn't the answer because this options only changes the settings of the font (i.e. size, weight, etc.) but not the font itself. In my case, I prefer fixed-width fonts (like consolas) to be the font for all of my data views. –  RLH Apr 26 '12 at 12:13
    
Sorry about that. I have the answer and will edit my answer. –  CHarmon Apr 26 '12 at 14:01
    
Bingo! Wow, seems easy enough but how did you figure this one out? I couldn't find this solution any where in the web and it's quite simple. Thanks a ton! –  RLH Apr 26 '12 at 14:19
    
Oh, it's also worth mentioning that no reboot "of the PC" is necessary. I still needed to close Access (I had a few DB and numerous tables/queries opened this morning) for this change to take affect. But, that type of behavior isn't unexpected. –  RLH Apr 26 '12 at 14:22

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.

share|improve this answer
1  
This does not change the default font, just for this one datasheet. –  slhck Aug 24 '13 at 15:50

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.