Maximize on startup

Hello Geek,

Please help me to maxamize the main window on startup. I have 2 Access apps running for 2 departments and some users use both. Sometimes the main window opens small but i want to use all the screen space.

Thanks,

M
LVL 3
MootherAsked:
Who is Participating?
 
Sayad Aziz AhmadCommented:
use

Private Sub Form_Load()
 DoCmd.Maximize
End Sub
0
 
jjafferrCommented:
Hi Moother,

make a maco, in the Action column, select the following:
OpenForm, in the properties, select the Form Name,
maximize
save as autoexec

I hope this helps.

jaffer
0
Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

 
MootherAuthor Commented:
Thanks, but maybe i didn't explain fully.

I know how to maxamize a form, but it's the main window of the app i want to go full screen.

Maxamizing a form only makes it as big as the main window allows but doesn't give my app the full screen i need.

Thanks,

m
0
 
jjafferrCommented:
Moother,

Private Sub Form_Load()

'DoCmd.MoveSize Right, Down, Width, Height

'example
           DoCmd.MoveSize 4000, 3000            'this will move the 3" x 5 " form at the center of 21 inch monitor

end sub

got it from capricorn1's comment in http://www.experts-exchange.com/Databases/MS_Access/Q_21125698.html
0
 
jjafferrCommented:
your concern is in the width and the Height

when you stretch your Form to the max, look at the value in the Form properties, then plug them in the code
keep in mind 1"=1440 twips
0
 
jjafferrCommented:
you better look in the link I gave you, as there is another example I posted at the end, which might help too
0
 
MootherAuthor Commented:
allright... should have enough to go on here...

will revert soon...

have a wonderfull Sunday... hope you're not stuck in the office like me...
0
 
jjafferrConnect With a Mentor Commented:
Moother, I think you should try what danny pointed to, it looks the best solution, and it is summarized like this:

instead of using

DoCmd.Maximize

use

DoCmd.RunCommand acCmdAppMaximize

(Docmd.Maximize only maximizes the active internal window/form/report/etc)

where as DoCmd.RunCommand acCmdAppMaximize will maximize the application window
0
 
MootherAuthor Commented:
Fantastic jjaffer...

I'll get right onto that one!!!
0
 
MootherAuthor Commented:
thanks Geeks!

had to split there because jjafferr pointed me in the right direction...

had no time to follow the links so thanks both for your help...

M
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.