Access Form Sizing

[AccessFreak]

Hi

I am building a database in Access2007. All the forms are set to "pop up"

and each form has DoCmd.Maximize attached to them as the client does not wish to see any "access" screens. All the screens / forms open fine on my pc. But when opened on the client's laptop, all the forms resizes and are "scew"

Is there any way to adjust the size of each form so that it first checks the size / resolution of the screen before resizing and maximizing each form?

Thank you

Melissa

[RuralGuy]

You may find this link helpful: http://www.mvps.org/access/api/api0012.htm

[pdebaets]

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

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

There's a form resizer at http://www.jamiessoftware.tk/resizeform/rf_jump.html .

Another one: http://sourceforge.net/projects/modscaleform

The Access Developer's Handbook has form resizing code included:
http://www.amazon.com/exec/obidos/IS...064361-7403703

Hope this helps,

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