Resizing form to fit resolution

[Taagen]

What VBA code do I set to have my form automatically resize for each particular users screen resolution? Thanks.

 

[ghudson]

Searching this forum for Screen Resolution will get you results like this thread...

Screen Resolution

HTH

 

[Peter D]

There are third-party form scaling solutions available that might help:

A shareware version of a form rescaling module I wrote called ShrinkerStretcher is available at this web site: http://www.peterssoftware.com/ss.htm

FMS has a sizer module at www.fmsinc.com.

The Access Developer's Handbook has form resizing code included:
http://www.amazon.com/exec/obidos/ISBN=0782119417/107-8064361-7403703

For more informmation, there are some great articles about form scaling in the December 2000, and May 2001 SmartAccess newsletter. Check it out here: http://www.smartaccessnewsletter.com

Hope this helps,

 

[Autoeng]

I utilize the one located at www.developershandbook.com/downloads.htm. Very easy to implement and works very well.

One caution though. Disable the resizer when working on your form in design view or things get screwed up in size. Once you are happy with design enable the resizer and you are good to go.

Autoeng