Hello. My question pertains to the screen resolution. I am wondering if it
is possible for Access 2003 (eventually to 2007) to change the screen
resolution when it opens and closes. What I would like to do is have the
application open up and change the users screen resolution to a predetermined
size. Can this be done? If so, how as I am not that good with vba code?
Also, when the user closes the application, the screen resolution is restored
back to what it was before the app opened up. Is this possible? If so, how
(same reason as above)?
Thanks for responding.
... John
Rick Brandt - 28 May 2008 12:10 GMT
> Hello. My question pertains to the screen resolution. I am
> wondering if it is possible for Access 2003 (eventually to 2007) to
[quoted text clipped - 7 lines]
> Thanks for responding.
> ... John
Possible in some PC setups, not in others, and always a terrible idea. You
don't sometimes toggle between two different programs on your PC? Merely
setting the resolution back when your app is closed would not be acceptable
to hardly anyone and your app would just look amatuerish for the need to do
so.
Games are the only acceptable case for changing a user's resolution and I
don't know if even they have done that for a while now. You just need to
design your app for a minimum resolution specification using your user-base
to establish what that minimum size is.
With the proliferation of LCD screens now you could possibly change to a
resolution that the user's display doesn't even support causing them to lose
their display entirely or at least distort it beyond usability.

Signature
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
Rick A.B. - 28 May 2008 13:56 GMT
> Hello. My question pertains to the screen resolution. I am wondering if it
> is possible for Access 2003 (eventually to 2007) to change the screen
[quoted text clipped - 6 lines]
> Thanks for responding.
> ... John
John,
There is a program called Reschange.exe. You can find it at
http://www.12noon.com/reschange.htm
I have never used it for an access app but I do for a Terminal program
and it works well.
Hope that helps.
Rick
Daniel Pineault - 28 May 2008 14:35 GMT
You can make your forms dynamic and adjust to the user's resolution. Check
out the code at http://www.mvps.org/access/general/gen0002.htm

Signature
Hope this helps,
Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.com/index.php
Please rate this post using the vote buttons if it was helpful.
> > Hello. My question pertains to the screen resolution. I am wondering if it
> > is possible for Access 2003 (eventually to 2007) to change the screen
[quoted text clipped - 18 lines]
>
> Rick