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
Avatar of Jim Dettman (EE MVE)
Jim Dettman (EE MVE)
Flag of United States of America image

<< 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.

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.

Avatar of Helen Feddema
Helen Feddema
Flag of United States of America image

Blurred text
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
Avatar of koughdur


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.
Avatar of koughdur



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.
Avatar of koughdur


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.
Microsoft Access
Microsoft Access

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews


IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo