I strongly recommend against that. Messing with the user's settings is
generally considered to be a bad thing. I know I'd certainly scrap your
application if you changed my resolution! Remember: your application isn't
the only thing running on their machine.
More common is to adapt your forms to their 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, though, Randy Birch has sample code at his VBNet site.
See, for example,
http://vbnet.mvps.org/code/enums/enumdisplaychange.htm
(Obligatory warning: Randy's site is aimed at VB programmers. Because there
are significant differences in the controls available on forms in VB and in
Access, some of his code samples won't port directly into Access. I'm afraid
I didn't look that closely at this one, so I'm not sure whether it fits in
that category)
