Form RESIZE

[Taagen]

Boy, did I state that wrong. There seems to be some VBA code out there that will resize the FORM to a user's particular screen resolution, not the other way 'round. I completely mistated my original question. Is there such a code and is it at all worth the time and trouble?

Thanks all.

 

[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

 

[Hayley Baxter]

I used this link posted by Anauz it works very well. Now you have a few options to do the job for you.

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=19648&highlight=resize+screen

Hay