MAXIMISE form on opening

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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
 
In the on open event of the form set to [Event Procedure] and put this code
DoCmd.Maximize
 
Thanks both of you Denis and Nickos it solved my problem.
--
Philip wiskes to thank you for your help.


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

Philip from Malta Europe said:
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?
Click to expand...
Click to expand...
 
Back
Top