Start-ups and form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
In the Open event procedure of your form, include this line of code:

DoCmd.Maximize
 
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.
 
Yes, the Activate event makes sense if you want the form to fill the Access
window whenever it takes focus.
 
Back
Top