Switchboard does not return full screen

mtagliaferri

Board Regular
Joined
Oct 27, 2004
Messages
156
I have set the switchboard to maximise when opened, when I open any form fand then close it the switch board will not return at full screen, How can I have it maximise every time a form is closed!!!
 

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)
Open your Switchboard form in design mode.
Open properties and click on Events

For the OnOpen Event, enter...

DoCmd.Echo False
DoCmd.Maximize
DoCmd.Echo True

You could also put this in the OnActivate Event.

The Echo False/True will freeze your screen and is more pleasing to the eye that if you leave it out. Not needed to make the maximize portion work though.
 
Upvote 0
Thanx but seem not to work! this is the code I have:
' Move to the switchboard page that is marked as the default.
Me.Filter = "[ItemNumber] = 0 AND [Argument] = 'Predefinita' "
Me.FilterOn = True
DoCmd.Echo False
DoCmd.Maximize
DoCmd.Echo True
Dim i As Integer
For i = 1 To CommandBars.Count
CommandBars(i).Enabled = False
Next i

Any other suggestions?
Marco
 
Upvote 0
Again,

Open your switchboard in design mode.
Click your right mouse pointer on the black square block in the upper left corner off the form. Select Properties.

You should have an display window showing 5 tabs... the middle one is Event... click your left mouse pointer on this.

Click the left mouse pointer to the right of the line that says On Open
You should see ... if you do this correctly.

Click on the button displaying ...
Select Code Builder

Enter the three lines of code I already gave you.

Save and try again.
Done correctly, It does work.
 
Upvote 0
Also... again,

If you HIDE your Switchboard rather than closing it everytime you move to another form, you will need to put this code into the On Activate Event rather than the On Open Event.

Then, everytime the Switchboard becomes the active form, that code will execute.
 
Upvote 0

Forum statistics

Threads
1,224,427
Messages
6,178,588
Members
452,860
Latest member
jroberts02

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top