Microsoft Access: Maximize a Form when it is opened

There may be a form you always click the Maximize button for whenever you use the form. Save yourself and other users of the form some time and set the form to maximize as soon as the form is opened.

1. Open the form in Design view.
2. In the Properties dialog box, select the Event tab.
3. For the On Open property, select [Event Procedure] from the drop-down list.
4. Click the Build button [. . .] to open Microsoft Visual Basic Editor.
5. Type: DoCmd.Maximize
6. Save your changes in the Visual Basic Editor and close. You’ll be returned to your Access database.
7. Save your changes to the form and close.

The next time a user opens that form, Access will automatically maximize the form within the main Access window.

If you have any questions regarding this tip or need help implementing it in your own projects, contact Ranelle Maltas, Application Support Associate, at 472-0585 or e-mail at rmaltas2@unl.edu.