How do you control the size Access 2003 opens to?

[M Skabialka]

All of the forms and reports in my database maximize when opened, but the
forms were designed to look best at 8 inches wide x 5 inches high. Some of
our users have a very high resolution on their monitors so if they open
Access maximized, all of the information in the forms is over there at the
top left of their screen.

Is there a line of code which I can run when this database opens to make the
Access Application shrink to the 8 x 5 inch form size to give the best look
to the application? And maybe a maximize for when they exit Access?

Thanks,
Mich

 

[Douglas J. Steele]

The short answer is no, there's not a "line of code".

It's considered extremely rude to change user settings: remember that
changing them will result in a change for all applications that are running
concurrently. The normal approach is to resize your forms to match the
user's resolution, not vice versa.

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.