Form appearance

[JeffH]

I have a database application that is used on several different computers
with differnt monitors. While the forms fit nicely on my laptop, they are
too large for a couple of the user's monitors.

I have the property of the form set to Yes for Auto Resize but this doesn't
help.

How can I make sure the Forms re-size automatically to fit on any monitor?

 

[Rick Brandt]

I have a database application that is used on several different
computers with differnt monitors. While the forms fit nicely on my
laptop, they are too large for a couple of the user's monitors.

I have the property of the form set to Yes for Auto Resize but this
doesn't help.

How can I make sure the Forms re-size automatically to fit on any
monitor?

You would have to include code that would programmatically resize and
reposition all of the objects on the form and then the form itself.

There are utilities available that will do this but generally they do a
better job of making forms larger than they do at making them smaller.

Generally you need to design forms to fit on the lowest resolution screen
you intend the app to be used on.

 

[Jerry Whittle]

While there is some code out there to resize forms, I find it easier to
develop Access applications at the lowest common denominator. One of the
questions on my development checklist is the minimum screen resolution and
colors. I develop to that.

I also test on an old, decrepit computer to make sure that raw cpu power and
memory aren't hiding any performance issues.

 

[pddxxx]

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/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/ISBN=0782119417/107-8064361-7403703

Hope this helps,

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