Change resolution when opening Access

[Arnon]

I built an Access database using 1024 by 768 pixels resolution. All forms are
shown nicely using this resulution by not on computers using other
resolutions (usually lower). Can I make Access change the resolution when
opens and restore the original one of the user when shutting off? That will
be a great help since I would like the users to be able to work soon.

On another issue, I built an autoexec macro which hides the database window.
However, if one hits F11, it's possible to change things and I don't want
that. Is there a way to tackle this?

Thanks in advance for your help,

Arnon

 

[Douglas J Steele]

You can, but you shouldn't.

The user has (probably) chosen their particular resolution because they have
a need for that resolution (for instance, perhaps they're vision-impaired,
so can't operate at a higher resolution). As developers, it's our
responsibilty to live with the user's settings.

What you can do is develop at a lower resolution, and include code in each
form to resize the form if a higher resolution is discovered. Grab a copy of
the Access Developer's Handbook (by Litwin, Getz et al) for sample code.

For your second question, you can create an AutoKeys macro that remaps what
F11 does. Yes, there are ways to open the database window without using F11,
but if your users know how to do that, they probably know other ways to be
able to change your application.