Setting form size for various monitors.

[Liz]

I have created a Access 2003 database that is used at several work stations
with monitors ranging from 15" to 21". My forms appear fine on the 19" and
20", but on the smaller monitor some of them are off to the side or below the
switchboard, requiring scrolling to get to them. These are not huge forms,
most of them are fairly small, but they scatter haphazardly across the
desktop.

I've set them to autocenter, and not. I've placed them where I wanted and
selected "no" to moveable.

Not sure what to do next.

Any help would be greatly appreciated.

Thanks

 

[Rick B]

You might want to search previous posts. This is a pretty common question.
I have seen answers that include links to some tools that help Access resize
the forms depending on the monitor being used.

The other common answer is to build for the lowest common denominator. In
other words, build the forms to work on the smallest monitors.


Rick B

 

[Tru]

There is an excellent book that addresses this specific problem, "Access
2000, Developer's Handbook by Ken Getz, Paul Litwin and Mike Gilbert, ISBN
0-7821-2370-8. I personnally create my forms for monitors 1024 x 768 and
warn the users if their monitor is not set to this resolution to change it to
this resoultion.

 

[Peter's Software]

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

A shareware 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/ .

The Access Developer's Handbook has form resizing code included:
http://www.amazon.com/exec/obidos/ISBN=0782119417/107-8064361-7403703

Hope this helps,

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