Screen Resolution vs. Form Size

[Mitch_____W]

I have created forms which fit nicely within my PC's 1024 resolution, however when end user's with a 800 resolution use my forms the forms are larger than their screen and they must scroll around to see all of the form. I recall reading about a way to remedy this with some code but I cannot find that info. Anyone have any ideas?

Thanks in advance!!!

 

[DJN]

Hi Mitch.

The Dev Ashish site has the answer to this one. Just follow the link and search for screen resolution. http://www.mvps.org/access/_vti_bin/shtml.exe/search.htm

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