Macro Maximize Form On Open (1 Viewer)

access2010

Registered User.
Local time
Yesterday, 18:37
Joined
Dec 26, 2009
Messages
696
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

The Mailman - AWF VIP
Local time
Today, 03:37
Joined
Aug 11, 2003
Messages
11,696
IIRC there are properties on the form that you can set to fill the entire screen.
 

Isaac

Lifelong Learner
Local time
Yesterday, 18:37
Joined
Mar 14, 2017
Messages
4,339
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

I’m here to help
Staff member
Local time
Yesterday, 18:37
Joined
Oct 29, 2018
Messages
14,560
Hi Nicole. There should be an equivalent macro, I think, called Maximize.
Sent from phone...
 

Cronk

Registered User.
Local time
Today, 11:37
Joined
Jul 4, 2013
Messages
2,487
Actually the macro command is MaximizeScreen. The macro can be put in the form's onLoad event
 

theDBguy

I’m here to help
Staff member
Local time
Yesterday, 18:37
Joined
Oct 29, 2018
Messages
14,560
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

Member
Local time
Yesterday, 18:37
Joined
Oct 4, 2015
Messages
155
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

CID VIP
Local time
Today, 02:37
Joined
Jan 14, 2017
Messages
14,697
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

Member
Local time
Yesterday, 18:37
Joined
Oct 4, 2015
Messages
155
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

CID VIP
Local time
Today, 02:37
Joined
Jan 14, 2017
Messages
14,697
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

Registered User.
Local time
Yesterday, 18:37
Joined
Dec 26, 2009
Messages
696
Thank you for all your suggestions.
The code which we have decided to use is = DoCmd.Maximize

Nicole
 

vhung

Member
Local time
Yesterday, 18:37
Joined
Jul 8, 2020
Messages
192
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...
 

Users who are viewing this thread

Top Bottom