How to Maximize a Startup Window

[Gandolf]

Access 97:

In an effort to tweak a database for optimal acceptance by users, I would like to know if this is possible:

As you know... from the /Tools/Startup... window you can select which object to display upon startup. For me, it is an input form. My form is used best and looks best if it is maximized. I would like to know if I can force it to Maximize upon startup so that the users do not need to see it in anything less than its best form. Thank You!
...grb

 

[RonB]

maximize

on your form find its On Open Event
In VB editor for that event type

docmd.Maximize

 

[Mile-O]

Rather than use the OpenForm method from the startup, use an autoexec macro:


in the macro set the commands thus:

OpenForm
Maximise


Save it as autoexec

 

[ghudson]

'Put this in your main forms on open event
Private Sub Form_Open(Cancel As Integer)
DoCmd.Maximize
End Sub

'Maximize your database Access window
DoCmd.RunCommand acCmdAppMaximize

HTH

 

[Gandolf]

WOW!

Thanks to you all for the excellent & quick responses! I'll put them to good use.

...grb

I've just returned from my workstation (yes, I have to go to the other end of the bldg, to access this web site), and I want to let you know:
I could not find an On Open event in my forms properties, so I tried Mile-O-Phile's solution first, and it works great. I really appreciate the contributions from you all. ...grb