Maximising Screen

[Guest]

I just did a search on these threads to look for a way to maximise the screen
when you open a form. I got an instruction : "Put a DoCmd.Maximize in the
Form's Open event". I would really appreciate if someone could explain where
the 'open event' is in the form ( I do not know vb and am finding my way
around creating a database). Thank you!

 

[Douglas J. Steele]

With the form open in Design mode, ensure you've selected the form itself,
not one of its controls, by clicking in the square in the upper left-hand
corner. Make sure the Properties window is open (select View | Properties
from the menu if it isn't). The middle tab on the Properties window will be
Event. Find the On Open entry, use the combo box to the right of that label
to select [Event Procedure] and click on the ellipses (...) to the right of
the box. You should be taken into the VB Editor, with the following lines
pretyped for you:

Private Sub Form_Open(Cancel As Integer)

End Sub

Type DoCmd.Maximize inside that, so that you end up with something like:

Private Sub Form_Open(Cancel As Integer)

DoCmd.Maximize

End Sub

 

[Guest]

Thanks Douglas! Instructions were perfect. I think you gave me my first
lesson in VB!! Thanks and happy new year.

With the form open in Design mode, ensure you've selected the form itself,
not one of its controls, by clicking in the square in the upper left-hand
corner. Make sure the Properties window is open (select View | Properties
from the menu if it isn't). The middle tab on the Properties window will be
Event. Find the On Open entry, use the combo box to the right of that label
to select [Event Procedure] and click on the ellipses (...) to the right of
the box. You should be taken into the VB Editor, with the following lines
pretyped for you:

Private Sub Form_Open(Cancel As Integer)

End Sub

Type DoCmd.Maximize inside that, so that you end up with something like:

Private Sub Form_Open(Cancel As Integer)

DoCmd.Maximize

End Sub



--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

I just did a search on these threads to look for a way to maximise the screen
when you open a form. I got an instruction : "Put a DoCmd.Maximize in the
Form's Open event". I would really appreciate if someone could explain where
the 'open event' is in the form ( I do not know vb and am finding my way
around creating a database). Thank you!