How do I prevent my forms from maximizing to fill the whole screen when they are opened? I would like for them to open to the size I specify.

Private Sub Form_Open(Cancel As Integer)
On Error GoTo Form_Open_Err

DoCmd.MoveSize 4320, 1440, 5184, 4896


Form_Open_Exit:
Exit Sub

Form_Open_Err:
MsgBox Error$
Resume Form_Open_Exit

End Sub

A "DoCmd.Restore" in your form OnOpen, or OnActivate event procedure may help.

Peter De Baets
Peter's Software - MS Access Shareware and Freeware http://www.peterssoftware.com