Form Open by Command Button

[end922]

Greetings,

wondering if there are any tips or tricks to getting a form to open maximazied after clicking on a command button. I have tried to size the form in design view then save then open form again. doesn't seem to work. In the properties of the form there is only a width property and not a height.
Thanks,
a little frustrated.

 

[Remou]

You can use:

DoCmd.Maximize

 

[kdart301]

Hi,

In design view of the form in question, in properties for the form go to the event tab and onopen add this code....


Private Sub Form_Open(Cancel As Integer)
DoCmd.Maximize

End Sub


Hope this helps....


Ken

 

[end922]

Thank you both! worked.