Maximize a form on open

[Guest]

I have a form that needs to be maximized in order to see all of the controls.
The form will be used by someone that is not very computer savvy & I would
like it to "Maximize" automatically on opening, rather then telling them that
they have to "click on the box in the upper right hand corner". Is there a
way to do this?

Garry Gross

 

[Richard]

Hi Garry

You can do it on the OnOpen Event of the form.

At design view of the form, on the Event tab of the properties form, go to
On Open and choose "Event Procedure". It will bring you to the VB Editor.
Add the code, "Docmd.Maximise"
it will open the form maximised.

Hope this helps
Richard