How do I set a form to auto open to max size?

[freedomyou]

How do I set a form to automatically open to maximium viewable size?

 

[tlbroadbent]

Use DoCmd.Maximize in the Form Open Event.

Private Sub Form_Open(Cancel As Integer)
DoCmd.Maximize
End Sub
Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions in the SQL Server forum. Many of the ideas apply to all forums.

 

[freedomyou]

SOOOO cool. Man that was irritating me. Now it just pops opem at max.

THANKS

 

[WildHare]

A thing to remember is that one you issue the MAXIMIZE command, any other open forms and reports will also be maximized. This may or may not be an intended effect. Since a lot of my apps use invisible forms, I tend to work in this sequence:

1) Make current form Invisible.
2) Open next form.
3) Maximize it.
4) Process....
5) RESTORE current form. (Docmd.Restore)
6) CLOSE or make invisible 2nd form.
7) Re-visible first form

Following this process, the first form always reappears the same size it was before it was hidden. IF you skip step 5, Form #1 will reappear maximized.

Jim



Jim Hare
"Remember, you're unique - just like everonone else"

http://www.jmhare.com