Resizing Forms

[mrssevans]

I created all my forms in 1024x768 and all my users are using 800x600 and they have a hard time seeing all the form. Is there any code that can fix this? Thanks

 

[D.Mair]

It is Posible There is code in Access 2000 Developer's Handbook, by Ken Getz, Paul Litwin, and Mike Gilbert.
There website has the chapter about resizing forms on it. http://www.developershandbook.com
The code for 2000 and 97 is there I think.

Hope this helps you.

David

 

[Peter D]

You can use a third-party form rescaling module or add-in to resize your forms for you, or write the code yourself, but it is quite involved.

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%3D0782119417/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,

Peter De Baets
Peter's Software - MS Access Tools for Developers http://www.peterssoftware.com

 

[CutAndPaste]

No new info on this, other than to say I've used the Litwin, Getz & Gilbert Re-size code quite a few times, it works realy well, though sometimes you have to be careful putting fields or objects close to the edge of a form.

The book has lots of other good code examples as well, it's worth the money!
(No, I'm no relation..)