How to keep form sizing when startup form is maximized

[Kelly R]

I want my startup form to be maximized when I open the database but then I want the forms and reports that I open to not be maximized. How do I keep the main form maximized and customize my other forms and reports to open not maximized?

[colintis]

In your startup form, open design view and open it properties.

Click the "Event" tab, click on the "On Load" text field, and click the "..." button appeared on the right, and select "Macro Builder"

After the macro window pops up, on the action column click the down arrow button, find and select Maximize. Then save and close.

[NeoPa]

First of all, Access (as with all Office Apps) has a common setting for windows being maximised. If one window is maximised then all windows are. That means you cannot have the startup window maximised at the same time as having other windows restored.

You can change the state dependin on which window has the focus though. There are various events you could use to handle this, but Private Sub Form_GotFocus() may be your best bet.

For your main form :

Private Sub Form_GotFocus()
    Call DoCmd.Maximize
End Sub

For all other forms :

Private Sub Form_GotFocus()
    Call DoCmd.Restore
End Sub