Automatic Sizing of Access Forms

[jweber]

I am working on an application for multiple users. Some of them have their monitor settings at 800 X 600(pixel) instead of 1024 X 768. This causes the forms to be "blown up" and makes them have to scroll. Is there a way to have access automatically size the app according to screen settings? Has anyone had a similar problem?

 

[hwkranger]

see help topic:

size, forms

See the Height, width property, use that to set the auto size feature.

if you have any more questoins, please feel free to ask Cruz'n and Booz'n always.
This post shows what little I do at work.

 

[khwaja]

Yopu can try using a utility provided by authors of Access 2000 Developer's Handbook( Ken Getz,Paul Lirwin and Mike Gilbert). Try

http://www.developershandbook.com

for further details. This worked well for me but the only caveat is that if someone is using a laptop, the form spread becomes rather screwy. Desktops are fine.

HTH Cheers

Arshad Khwaja

 

[KUZZ]

I had the same problem, but at much higher resolution. I have tried some demo versions of resizing forms, which i have found on the internet. After a long time of looking around I've realized that there are only 2 solutions.

1. Split your database (make sure to make a backup copy before doing so). And make 2 Front ends, 800 by 600 and 1024 by 786 and install them on the respective computers. This solution works great but is rigid, in terms of FE development.

2. Make your database forms in the lowest resolution available with your end users. Keep them nice and simple and easy to use, and the people operating at higher resolutions will not have problems reading them.


All the rest will simply consume your time, and will not provide an acceptable result (in terms of quality) Good luck,
Kuzz

"Time spent debating the impossible subtracts from the time during which you
can try to accomplish it."

 

[jweber]

Thanks Kuzz!

This sounds like the most practical solution. I tried some of the others, but you had the same problem. I appreciate the response!