Re: multi-resolution environment

From: Chris Mills (phad_nospam_at_cleardotnet.nz)
Date: 08/13/04


Date: Fri, 13 Aug 2004 15:51:58 +1200


> 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

"Nancy" <nospam.ncdocken.please@msn.com> wrote in message
news:469f01c47fd3$49205820$a401280a@phx.gbl...
> 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.