multi-resolution environment

[Nancy]

Hi,

Is there a way to set up an Access database so it always
expands itself to full-screen, no matter what resolution
the user chooses?

I have a client where one worker always sets her display
at 800x600, while another sets his at 1280x1024. Both are
stubborn people, and making either reset their display
each time could be a deal breaker. Everyone else in the
group uses 1024x768, but these two are the company
principals...and married.

YIKES! As always, I truly appreciate any advice you can
offer.

 

[Chris Mills]

YIKES! As always, I truly appreciate any advice you can

offer.

Never get married.

Is there a way to set up an Access database so it always
expands itself to full-screen, no matter what resolution

Yes & no.
You can sprinkle DoCmd.Maximize through your code, or especially at startup.
That maximizes forms within the Access screen, but not the Access screen
itself. To do that you'd have to do Windows calls (I imagine) or it's a choice
in the shortcut.

Why bother? (apart from maximizing at startup). Like most, my forms are
designed for "maximized", if they want to run crippled then just don't
suppress the maximize buttons so at least they can re-maximize if they want
to.

I have a client where one worker always sets her display
at 800x600, while another sets his at 1280x1024. Both are

That's more important. I run code to detect screen size, and code at the
startup of appropriate forms to shift all the form objects around or re-size
them to make use of the available screen size. I think there are more
professional examples than I can provide, but I forgot the URL hopefully
someone will come along soon. Anyway, mine is not a general routine.

Married principals...sheesh...
Chris