open form Maximized

[Chazcoral]

I have my database set up to open to a specific form, but the form opens in restore down mode, rather than maximized. How can I make it open maximized?

[pbaldy]

Try

DoCmd.Maximize

in the Open (or Load) event and

DoCmd.Restore

in the Close (or Unload) event.

[Flekrad]

I have used the DoCmd.Maximize
in Open event and it works great`..
My question is what does the DoCmd.Restore do and why would it be needed ??

[pbaldy]

It would be needed if you don't want other forms maximized. By default, when you maximize one and then close it, others would be maximized (unless their settings prevented it).

[Flekrad]

Cheers for the response, explains why others had opened maximised (occassionally) after I had edited 1 of the forms to max .

[DrChocolate]

I was trying all sorts of stuff to do this maximizing and here it is in all its simplicity and glory. Thanks for answering the tricky and also these "simple" questions.

[pbaldy]

Happy to help...send chocolate!!

[DrChocolate]

Paul -- You're very welcome -- if you don't mind my asking (since I probably shouldn't be using this as a way to find traffic directions), where would be the best thread to enter to ask about trouble I'm having with taking the SQL from a Access 2010 query and plugging it into a VBA iteration through the query (strSQL) -- it's being rejected as I type with an error message (asking for a label, a statement, an end of statement)... etc. Thanks for playing traffic cop (and if there's a place I can send you a web link wtihout revealing my identity to the entire world, I'll be glad to show you something chocolate to drool over.

[pbaldy]

I would just start a new thread in the appropriate forum (from the sound of it, Programming or Queries). I'll keep an eye out for it, or send me a link to it. You can email me at

pbaldy
gmail
com