Macro to open form at the Maximum Size

[access2010]

We use macros often and would like to have the form open at Maximum size

Could I please receive a suggestion on how to do this as, the above does not work.

Thank you.
Crystal

 

[theDBguy]

Hi. Have you tried using Maximize in the Form's Open event?

 

[arnelgp]

open the Form in design view.
add code to it's Open event:

Private Sub Form_Open(Cancel As Integer)
DoCmd.Maximize
End Sub

 

[access2010]

arnelgp and theDBguy
P.E.R.F.E.C.T, Thank you both

Nicole​

 

[theDBguy]

arnelgp and theDBguy
P.E.R.F.E.C.T, Thank you both

Nicole​

Hi. Glad to hear you got it sorted out. Cheers!