Maximize Form on Opening DB via Macro

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

Guest

I assigned a Macro to open up the DB with a specific form. But when I open
the DB the form and Access both open up Minimized. Can someone please help me
and have the DB and form open up Maximized.

Thanks!!
 
Go into design view on the form which opens up when the DB is opened and on
its OnOpen event property type the following line of code:

DoCmd.Maximize

Hope that helps.
 
I assigned a Macro to open up the DB with a specific form. But when I open
the DB the form and Access both open up Minimized. Can someone please help me
and have the DB and form open up Maximized.

Thanks!!
Click to expand...

1) To open the database to a specific form there is no need to use a
Macro (or Code).

Click on Tools + StartUp.
Enter the form name in the "Display Form/Page" drop-down box.

2) To have the form open Maximized, in Design View display the form's
property sheet.
Click on the Event tab.
On the OnOpen line write
[Event Procedure]
Then click on the little button with 3 dots that appears on that line.
When the code window opens the cursor will be flashing between 2
already existing lines of code. Between those 2 lines write:

DoCmd.Maximize

Close the code window and save the changes.
When the database first opens, this form will appear.... maximized.

Make sure that none of your current macros interfere with this method.
 
Back
Top