Avatar of koughdur
 asked on

Microsoft Access 2010: The Dark Side of Setting Text Size to 100%

The answer to question Q_27157742 (Eliminate Navigation Pane Jumpiness) was to set the Windows Screen Text Size to 100%.

That worked for me, however, the text in form labels and on buttons became bigger and was often cut off.  This is non-intuitive.  If anything I would have expected the text to get smaller.  This is on a Windows 7 system.

Has anyone else seen this?  I'm kind of stuck between a rock and a hard place.  Set the screen text size to 100% and eliminate the jumpiness, but then I need to reformat all my forms so the label text can be seen.  Or set the screen text size to 125% or 150% and the forms look fine, but the navigation pane jumpiness returns.

Any ideas?
Microsoft Access

Avatar of undefined
Last Comment

8/22/2022 - Mon
Jim Dettman (EE MVE)

<< but then I need to reformat all my forms so the label text can be seen.  >>

 Just need some code to run through all the forms, open in design mode, loop through the controls, change the font, and save.

If that's the route you want to go, I can help with that.

But you need to know what to go from to what.

Jeffrey Coachman

To me, the penalties for using the fix in Q_27157742, (changing font sizes), outweigh the issue itself.

IIRC, if you change the "View By" option, this may go away...
This is a finicky issue, I had it with 2007, but not with any other subsequent versions of Access.

Perhaps it is relate to the mouse scrolling options?
Perhaps you could investigate that as well.

Helen Feddema

View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.

Jim and Helen,

Thanks for the code, but I don't think it will help.  Most of the fonts I am using on the forms are set to 8, so setting them smaller will not work.  In most cases I will need to increase the sizes of buttons and labels and move everything around in order to fit it all onto the form.

I tried with one application.  If I can get the form to look nice with text size of 100%, then it looks nice with 125% and 150%.  So it looks like I'm going to have to hack away at this manually as I get time.
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy


I have tried all values of View and they all are jumpy.

The other problem with setting text size to 100% is that the text is soooo small.  I really like how things look at 125% or even better at 150%!

Still I'll probably go back to 100% to eliminate the jumps.

Thanks for the code.  I can't use it for this issue, but I may be able to use it in future on other projects.