Re-size forms to fit screen ...

[m.cringle]

Hi folks!

I have a database which is being shared with a number of other users.
The problem is that these users have different graphic cards and some
have different sized screens.

I even created a copy of the front-end for small screen users but even
using this does not suit others pc's!

Is there any way that I can somehow group all the fields, command
buttons, sub-forms etc and make them re-size to fit the particular
screen used? I also have an image as the background which may cause a
problem.

Any ideas?

(Sorry, I also posted this on microsoft.public.access.formscoding (or
something like) - was not sure how active that group was)

 

[Rick Brandt]

Hi folks!

I have a database which is being shared with a number of other users.
The problem is that these users have different graphic cards and some
have different sized screens.

I even created a copy of the front-end for small screen users but even
using this does not suit others pc's!

Is there any way that I can somehow group all the fields, command
buttons, sub-forms etc and make them re-size to fit the particular
screen used? I also have an image as the background which may cause a
problem.

Any ideas?

(Sorry, I also posted this on microsoft.public.access.formscoding (or
something like) - was not sure how active that group was)

There are utilitities and code routines that can resize a form based on the
user's resolution, BUT in my opinion they are of little practical value.

They are good at making forms larger on higher resolution screens, but that
is unnecessary and would be considered annoying by most users. Users of
hi-res displays don't want your forms to take up more of the screen with
ridiculously large controls and fonts. They want to see more stuff
on-screen at one time and a resizing utility would be contrary to that goal.

The utility/code routines are not nearly so good at making forms smaller so
they fit on lower resolution screens which is where they would actually be
useful and desirable. They *do* work in that direction but certain types of
controls (subforms, TabControls, etc.), don't shrink very well if at all and
you will see lots of text being cut off by the shrinking controls.

Your best bet is to design your forms so they fit on the smallest resolution
that you plan to support. The "standard" has been 800 by 600 but lately
many developers are moving to 1024 by 768 as their minimum spec.

 

[m.cringle]

Thanks for your advice.

I tried one of these add-ons but didn't really like the results (as you
expected), so I have redesigned my forms to fit a 1024x768 resolution.
Much better

Cheers