Start-ups and form

M

mdavis

In the start-up menu I changed the settings so the user will only see and
have access to the form when my DB is opened. The problem is the when the DB
is opened I want the form to take up the whole screen and it doesn't--I have
to continually click the expand button. Is there a way I change this?

Thanks! MD
 
A

Allen Browne

In the Open event procedure of your form, include this line of code:

DoCmd.Maximize
 
K

Klatuu

That will only suffice when the form is opened. If other forms, reports, etc
are opened while the form is open, it will resize (to me, the most maddening
behaviour of Access). My practice is to put the code in the Activate event.
 
A

Allen Browne

Yes, the Activate event makes sense if you want the form to fill the Access
window whenever it takes focus.
 
Top