AboutScottgem Expertise I can answer almost all types of questions relating to Microsoft Access usage and application design. My strengths are database and interface design.
Experience I've been designing databases for over 15 years working with dBase, FoxPro, Approach and Access.
Organizations Author of Microsoft Office Access 2007 VBA Techncial Editor for Special Edition Using Microsoft Access 2007 and Access 2007 Forms, Reports & Queries From Que Publishing
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