Expert: Scottgem - 7/1/2009

Question
To begin, I'm using Access 07 and for my database I set the Document Windows option to Overlapping windows.

I have my main form set to maximize upon opening (DoCmd.Maximize on the form's On Open event). However, I've found that when I click on a cmd button that opens another form and that form's Pop Up property = No (but it's modal property = Yes) it is maximized also, which I don't want. Why is that happening? I only want my main form maximized, not any other form.

Answer
This is a quirk in Access. When you maximize one form, all subsequent forms open maximized. If you Restore or Minimize a form, all forms are restored. That's why the Tabbed documents is a better choice for Access 2007, since it allows you to see all the open documents.

The best solution I can suggest is to try and size the main form so it fills the screen. This may mean detecting the resolution the monitor is set for and resizing the form accordingly. This way the main form is not in the maximized state but covers the screen.

Hope this helps,
Scott<>
Microsoft Access MVP 2007
Author: Microsoft Office Access 2007 VBA