Userform controls and Windows display text size setting

[GJL]

Normally I keep my Windows display text size setting at 125% (in Windows 7, Personalize | Display).

But if I lay out a userform with controls while on that computer, then run it on another computer with the default setting (100%), text seems to become bigger, or maybe the controls holding them become smaller. Anyway, text is cropped in labels, listboxes get vertical scrollbars they don't have on my computer, etc. Controls carefully laid out to work together, such as an edit box right next to a listbox item named "Other:", are positioned all wrong relative to each other.

Why would the text seem to get bigger when going to a smaller text size setting?

And, what's the best practice when developing for use by others on other computers? Default 100%? Smaller than 100% to cover users who may have their Windows text size set smaller?

Aside from leaving gobs of white space, is it possible to make text in dialog controls look the same size regardless of the Windows text size setting?


Thanks,

Greg

 

[NdNoviceHlp]

On all 4 of my pc's (Windows xp. vista and 07 with XL 2000, 2003, 2007 and 2010 with various screen resolutions from 1024x768 to 1366x768) whenever you change the dpi setting, the userform doesn't automatically resize to maintain it's original physical screen proportions. The userform size also gets adjusted with the dpi (ie. becomes 25% larger when the dpi goes from 100 to 125%). This results in large userforms no longer fitting the screen when the dpi is increased. The code provided produces the same screen proportioned userform for all of my pc's with the various os and versions no matter the dpi or screen resolution. Trial making a large userform with controls that almost fills your screen. Change your dpi and view your userform to see what happens. Then trial a similiar userform with the code. Functionality that I never new I needed until my kids messed with my dpi one day. HTH you. Dave