VBA userforms and Windows 7's custom dpi
Does anyone have any wisdom on this?
Windows 7 has a fairly cool feature that allows you to enlarge text and other items while retaining the native resolution of your display. I set mine to custom at 110%, but I have the following issue at any increased dpi.
If I open a userform in Word, the text and sometimes the controls get too big for the userform, or display over each other. The background graphic I have on the form doesn't get bigger, so sometimes I see the edges of the graphic within the enlarged userform.
Is there a way to increase dpi without affecting the userforms? On today's laptops, I can't imagine anyone not using the Set custom text size (DPI). Or, is there a way to have the userform and any graphics enlarge proportionally?
Any advice on how to design userforms for Windows 7? Thanks!!
For your interest - other languages
As a programmer on other systems, you may find it interesting to note that most other languages' dialog-box layout sytems automatically cater for widegets changing size. This can be when you translate the labels into another (more wordy) language, or change font sizes as you mention.
All the widgets 'jiggle' themselves under the direction of a 'layout manager' to stop them overlapping. It can be like a Word table resizing the columns.
It works this way in Java, Perl/Tk, Python Tkinter and others.
It's more work to set up to start with,though.