Window Size

So... If youve read any of my previous questions you'd know that i always
ask the most stupid or straight forward question so im gona pretend like this
one is a smart question...

Er...

So my issue is that when i build a database for a friend or whatever and i
deploy it to that machine then i have to make everything fit on the screen
all over again...

Why is that?!?! Isnt there like a magic button where you can just adjust
things so they fit on any users screen?

Can't recall where I got this snippet of info - possibly from this group or
a newsletter or website:

"We tend to design all our forms to comfortably fit on the lowest common
screen resolution -1024×768. A form to fit this size should be about 9.75
inches (24.8 centimeters) wide, and the sum of the heights of the sections
should be about 5.6 inches (14.2 centimeters) to allow space for the Ribbon,
status bar, and Windows taskbar. If your user has set a higher screen
resolution, and your application is designed using overlapping windows,
extra space will be available on the Access desktop to work with multiple
form windows at a time. If you are using tabbed documents, extra space
appears to the right and bottom of the form when the user opens it on a
higher-resolution screen."
9.75 inches may be half the width of your monitor if you have a hi res
setting, and wider than the screen on a lo-res setting your friend has. It
isn't like designing web pages, or Visual Studio where you can have fields
adjust to fit the width of the form as displayed. No magic in Access (yet!)
You will have to design your application based on the user settings.


"ant1983" wrote in message
...
So... If youve read any of my previous questions you'd know that i always
ask the most stupid or straight forward question so im gona pretend like
this
one is a smart question...

Er...

So my issue is that when i build a database for a friend or whatever and i
deploy it to that machine then i have to make everything fit on the screen
all over again...

Why is that?!?! Isnt there like a magic button where you can just adjust
things so they fit on any users screen?

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/IS...064361-7403703

Hope this helps,

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