setting size of form for different size monitors

[TimT]

Hello experts!
I have created a database program that will be used by our clients.
It will be packaged using the developer tools with Access 2003.
What I forgot to take into consideration while I was designing the Main form
was how it was going to fit on different monitors. As it is I was using a 17"
monitor with the settings at the highest resilution and it fit my screen
perfect.
After installing it on another machine with a different size monitor and
resilution setting of 1028x768 it looked like a Pacaso and was not user
friendly at all because you had to scroll too much.
So I had to redesign the whole form to a smaller size after I reset my
monitor to 1028x768.
Is there a way to automaticly size the form to adjust it's magnification for
any size monitor on any setting?
Please help! I'm beside myself here!

 

[Gary Miller]

Tim,

The author's of the Access Developer's Handbook ( a must
have if you are serious about Access ) put together their
code sample of tackling this problem an have generously made
it publicly available as an MDE file that you can reference
in your application.

Look for the Form Scaling/Resizing Tool under Recommended
Downloads.

http://www.developershandbook.com/downloads.htm

 

[Rick Brandt]

Hello experts!
I have created a database program that will be used by our clients.
It will be packaged using the developer tools with Access 2003.
What I forgot to take into consideration while I was designing the
Main form was how it was going to fit on different monitors. As it is
I was using a 17" monitor with the settings at the highest resilution
and it fit my screen perfect.
After installing it on another machine with a different size monitor
and resilution setting of 1028x768 it looked like a Pacaso and was
not user friendly at all because you had to scroll too much.
So I had to redesign the whole form to a smaller size after I reset my
monitor to 1028x768.
Is there a way to automaticly size the form to adjust it's
magnification for any size monitor on any setting?
Please help! I'm beside myself here!

There are code utilitities that do this but they are imperfect and they are much
better at making forms larger than the original than they are at making them
smaller.

What most developers do is design to a minimum resolution specification. For
most that is 800 by 600 although many are moving up to 1024 by 768 as larger
displays become more common.

 

[SF]

Dear expert,

Will Microsoft address this issue (form sizing) in the next release of
Access?

SF

 

[Douglas J. Steele]

I haven't heard whether or not they will, but I personally hope they don't.

I prefer being able to control how my application behaves, rather than have
it automated.

 

[mmellring]

Dear expert,

Will Microsoft address this issue (form sizing) in the next release of
Access?

SF