Switchboard - Open window

[mypig7]

I have created a switchboard.
When I click on a button (which I inputted) to open a form, the form opens but doesn't fill the screen.

How can I set it so that it does fill the screen.

 

[Joe4]

Maximize the form upon loading. See my answer in this thread:
http://www.mrexcel.com/board2/viewtopic.php?t=130926

 

[mypig7]

Switchboard problems - Opening Form

Hi,

I have tried to put this code into the Vb code, to get a form to fill the screen as soon as I click the relevant button on the switchboard :-

Private Sub Form_Load()

DoCmd.Maximize

End Sub

I'm not v.good at VB and am not sure where to paste it.
Is there another way?

Help!

 

[Joe4]

You really don't need to know any VB to do this.

All you have to do is open your form in Design View, and then view the Properties of the form.
Then go to the Event tab.
Find the "On Load" event, then click just to the right of the entry box and select the "Code Builder" option.
Then simply paste the code in the resulting box.

That's all there is to it!

 

[mypig7]

thanks

Many thanks