Form Sizing

[Ken Doran]

My problem is that several different users have different
screen resolutions, this causes problems when the form is
wider than the screen.

Is there a way of programming the form so it automatically
adjusts to the screen size?

 

[Wayne Morgan]

You will find information on what you are wanting to do here.

http://www.mvps.org/access/general/gen0002.htm

 

[Cheryl Fischer]

As installed, Access has no capability to do this. However, there is code
for this in the "Access xx.x Developer's Handbook" by Ken Getz et al.
The book is expensive, but the code found there is well worth the price.

hth,

 

[Paul Falla]

Dear Ken
If you follow the link below, you can download a utility
that will take all the hard work away from you. It has
full instructions on how to use it, and I have tried it
and now use it regularly with the forms that I design. One
thing to bear in mind, is to design your form at the
lowest screen resoltion that your users may have, as the
utility stretches the form better than it shrinks it.

Hope that this helps

http://www.jamiessoftware.tk/