Macro Maximize Form On Open

[access2010]

We use Macro Keys to open forms in Access 2003

Please suggest what we should do with our Macro to have the forms open at their full size.

Thank you

Nicole

 

[namliam]

IIRC there are properties on the form that you can set to fill the entire screen.

 

[Isaac]

I don't use macros, but if you insist on them, you can always call a function that runs this line of code: Docmd.Maximize
If maximize is what you're after

 

[theDBguy]

Hi Nicole. There should be an equivalent macro, I think, called Maximize.
Sent from phone...

 

[Cronk]

Actually the macro command is MaximizeScreen. The macro can be put in the form's onLoad event

 

[theDBguy]

Actually the macro command is MaximizeScreen. The macro can be put in the form's onLoad event

Hi. Thanks for the assist. I couldn't check earlier, since I was on my phone. However, I just checked my version of Access and my macro action is called "MaximizeWindow."

 

[onur_can]

You can create a simple autoexec macro for this. If you command Open Form, then maximize and set the name of the macro to autoexec, you can automatically maximize the screen when you open the application.

 

[isladogs]

Using an autoexec macro will only have any effect on the startup form.

@access2010
As others have indicated using macros is not the best way to handle this.
A better way would be to use DoCmd.Maximize in a Form_Load event procedure

OR if you want all forms to be maximized, you could use tabbed documents (A2007 or later)

 

[onur_can]

If you want to hide the access window and you have a form opened at the beginning, the path I suggest is ideal. Window hiding and maximum sizing can be done in Autoexec macro.

 

[isladogs]

Yes its fine to use an autoexec macro for the startup form only.
Having said that, there might be a slight flicker doing so as the startup form (surprisingly) loads before the autoexec macro runs.
However my main point was that you can't use autoexec on the other forms which the OP also wants to maximise.

 

[access2010]

Thank you for all your suggestions.
The code which we have decided to use is = DoCmd.Maximize

Nicole

 

[Isaac]

Thank you for all your suggestions.
The code which we have decided to use is = DoCmd.Maximize

Nicole

Glad to here you got something working

 

[vhung]

We use Macro Keys to open forms in Access 2003

Please suggest what we should do with our Macro to have the forms open at their full size.

Thank you

Nicole

We use Macro Keys to open forms in Access 2003

Please suggest what we should do with our Macro to have the forms open at their full size.

Thank you

Nicole

hello: if you use macro to open form, then add MAXIMIZE to your macro, to have Form full view...