Monitor size

[Robert Gillard]

In my office we have a sellection of monitor sizes (15,17,19inch). At the
moment if we write a program on one pc (say 15 inch monitor) when we come to
run it on the others the forms are either too big or to small for the screen
and we have to resize them all.

Is there something we can do when writing the program to make it auto fit
regardless of the size of monitor.

with thanks

Bob

 

[Douglas J. Steele]

Realistically, the size of the monitor is irrelevant: it's the monitor
resolution that matters.

One thing you can do is design for the lowest resolution (say 640x480 or
800x600) and then add code to resize your form if the user's resolution is
higher.

Best way to do this is to purchase whatever edition of Access Developer's
Handbook by Litwin, Getz and Gilbert is appropriate for your version of
Access. It contains complete code to do this (see
http://www.developershandbook.com/ for more details about these books)

If you don't feel like writing your own code, you can download a free add-in
at http://www.developershandbook.com/downloads.htm that will do it for you,
or you can purchase ShrinkerStretch from Peter De Baets
http://www.peterssoftware.com/

There's also http://jamiessoftware.tk/resizeform/rf_download.html although I
don't know anything about how good it is.