General discussion

Locked

Access Switchboard

By ljackson.desoto ·
Hello-
I am working with a database that has a switchboard. When you open, the switchboar and the main database open up in windows and then you have to maximize the switchboard.

I believe there is a way to make the switchboard maximize upon opening the database, but I don't know how to make this happen. Help!

This conversation is currently closed to new comments.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by Maevinn In reply to Access Switchboard

Open the form in design view, and open Properties for the form. Find On Open (either Event or All tab) and click to enter an Event Procedure.

In the Private Sub that is created, enter this:

docmd.Maximize

Save, and you're good to go. You can also create this as a Public Sub and have it apply to all forms as they open, but it can be a pill if you have anything where a user needs to have 2 things open at once (ie, a form and a report, 2 different forms, etc). Bulding it as a macro and applying it to specific forms as needed works as well, but I prefer using VBA code to macros.

Collapse -

by dpahari23 In reply to Access Switchboard

If you hide all other forms other than switch board, then you may not require to maximize the size of the switch boards.
To do this, if you go to Tools then to startup and select only the switch (form name) as a start up form.

Hope this helps.

Back to Software Forum
2 total posts (Page 1 of 1)  

Related Discussions

Related Forums