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

Fred Gardner 0 Reputation points
2023-06-20T00:28:11.1666667+00:00

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

Microsoft 365 and Office Access Development
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Tanay Prasad 2,250 Reputation points
    2023-06-20T07:11:16.4433333+00:00

    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.

    0 comments No comments

  2. Karl Donaubauer 2,061 Reputation points MVP
    2023-06-20T14:27:38.35+00:00

    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

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.