I want to change font size in VBA editor; when I change size usings TOOL tab it does not save?

Question

I want to change font size in VBA editor; when I change size usings TOOL tab it does not save?

Answer 1

Hi,

Normally the font size you choose in the Tools - Option - Editor Format dialog gets saved in the registry and therefore is a permanent setting. You can take a look (or even try it directly) at HKEY_CURRENT_USER\Software\Microsoft\VBA\7.1\Common\FontHeight.

There have been some reports for years that this permanent saving to the registry does not work. Most of them come from Excelians. Cause unknown. It is not clear if it is due to Office or VBA, Windows, a certain permission situation for the registry, some graphic setting/situation or whatever.

Servus
Karl

---

Access Bug Trackers
Access News
Access DevCon

Answer 2

Hi,

The font size setting in the VBA editor is not permanent and will not be saved for future sessions. The font size in the VBA editor is controlled by the Windows display settings. Changing the font size in the VBA editor will only affect the current session, and you will need to change the font size again if you close and reopen the VBA editor.

Here's how you can change the font size for the VBA editor by adjusting the Windows display settings:

• Right-click on the desktop and select "Display settings."
• In the "Display" settings window, scroll down to the "Scale and Layout" section.
• Under "Change the size of text, apps, and other items," you can adjust the slider to increase or decrease the font size.
• Once you've adjusted the slider, click "Apply" to save the changes.

NOTE- Changing the Windows display settings will affect the font size in all applications, not just the VBA editor in Microsoft Access.

Best Regards.