You sure about that? It's generally considered inappropriate to mess with
settings that the user has chosen. Remember that your application isn't
guaranteed to be the only one that's going to be running, and changing the
resolution will impact all applications running at that time. I know I'd
quickly scrap an application that insisted on changing my settings!
Far more common is to have your application adjust itself to the existing
resolution.
There's sample code to do this in Access Developer's xx Handbook by Litwin,
Getz and Gilbert et al (where xx is whatever's appropriate for the version
of Access you're using). You can learn more about their books at
http://www.developershandbook.com/
They've also produced an MDE version of the code that you can download from
http://www.developershandbook.com/downloads.htm and use in your application.
Another option is to purchase ShrinkerStretch from Peter De Baets
http://www.peterssoftware.com/
There's also code at
http://jamiessoftware.tk/resizeform/rf_download.html
but I don't really know anything about it.
If you're determined to do it, though, Randy Birch has code at
http://vbnet.mvps.org/code/enums/enumdisplaychange.htm that should help.
Note that Randy's site is aimed at VB programmers. Since there are
significant differences in the controls available on forms in Access and in
VB, some of his code doesn't port seamlessly to Access. I don't believe the
instructions for creating the menu selection will work in Access, but the
rest of the code will hopefully be usable to you.
