MAXIMISE form on opening

[Guest]

Hello anybody.

How do maximise a form on entry. When ever I open a form in Access 2002 the
form is in Mini size. I have to manually Maximise the form frm the top right
hand.

Any ideas?

 

[Nikos Yannacopoulos]

Open the form in design view, select the form object (Edit > Select
Form), display the Properties window (View > Properties), go totab
Events and put the cursor in the On Open property; click on the little
button with the ellipsis symbol (...) which appears on the right, and
select Code Builder; you will be taken to a VBA screen, and the cursor
will be in between the following two lines:

Private Sub Form_Open(Cancel As Integer)

End Sub

Paste the following in between:

DoCmd.Maximize

Return to form design and save (you can close the VBA window). This will
make the form maximize when opened.

HTH,
Nikos

 

[Guest]

In the on open event of the form set to [Event Procedure] and put this code
DoCmd.Maximize

 

[Guest]

Thanks both of you Denis and Nickos it solved my problem.
--
Philip wiskes to thank you for your help.

In the on open event of the form set to [Event Procedure] and put this code
DoCmd.Maximize

Hello anybody.

How do maximise a form on entry. When ever I open a form in Access 2002 the
form is in Mini size. I have to manually Maximise the form frm the top right
hand.

Any ideas?