maximize switchboard upon opening

[zrawe16]

I've created a database that opens showing a switchboard to access forms within. When I open the database the switchboard is not mamimized to show the full switchboard screen. This is a small issue, but I'd like to get it set up correctly. I hit the maximize button and then save the database, but when I close and reopen the database it's back to the same. Thanks for any input......

[ssanfu]

I've created a database that opens showing a switchboard to access forms within. When I open the database the switchboard is not mamimized to show the full switchboard screen. This is a small issue, but I'd like to get it set up correctly. I hit the maximize button and then save the database, but when I close and reopen the database it's back to the same. Thanks for any input......

In the load/close event of the form, add this code:

Private Sub Form_Open(Cancel As Integer)
   DoCmd.Maximize
End Sub


Private Sub Form_Close()
   DoCmd.Restore
End Sub

[zrawe16]

Is there a way to do this w.out code? I am not familiar w. where to copy and paste the code you provided. Thanks for your help.

[nicknameoscar]

I use Access 2000 and Access 2007 (work and that is where I am now) so I am not totally sure the below steps are a one for one match.

1. Open the switchboard form in design mode.
2. Right click the rectangle in the extreme upper left corner of the form.
3. Select Properties (at the bottom of the list).
4. Click on the Event tab.
5. Double click in the box next to "On Open". "[Event Procedure]" should appear.
6. Click on the box with the ... to the right. You should now be in the VBA editor. You should see:

Private Sub Form_Open(Cancel As Integer)
   
End Sub

Now make it look like this:

Private Sub Form_Open(Cancel As Integer)
   DoCmd.Maximize
End Sub

7. Click on the diskette icon in the upper left corner in the VBA editor OR close the VBA editor and click the diskette icon in the Access GUI. You are saving what you just did.

8. Test it
9. Repeat the above for the On Close event.

Hopefully you will find it fun. You are opening an entirely new world of capabilities by learning VBA.

[zrawe16]

Got it to work. Thanks!