VBA Code for Maximize

[Guest]

Hello.
If I wanted to create an Event Procedure for when the form loads and I want
it to maximize the form what would be the vba code?

Thanks.

Iram/mcp

 

[Douglas J. Steele]

DoCmd.Maximize

 

[Guest]

Hi Iram,

in the form open (or form load, or form activate) event, put the following:

docmd.maximize

Hope this helps.

Damian.

 

[storrboy]

Hello.
If I wanted to create an Event Procedure for when the form loads and I want
it to maximize the form what would be the vba code?

Thanks.

Iram/mcp

The event proceedure already exists - you can use either Load or Open,
or to ensure it's maximized anytime you come back to it you can use
GotFocus or OnCurrent.
DoCmd.Maximize will do the actual maximizing.

(Trying to maximize the number of time maximized is used in one post)