Automatically Maximizing a form

[Steve Jukes]

Is it possible to automatically maximize a form according to the users screen settings.

Any help much appreciated.

Steve

 

[chubbychap]

Steve

I don't know if this will work with different screen settings, but one way to maximise a form is as follows:

Set up an "AutoExec" Macro. This is a macro with is performed on opening up the database. If you want a particular form to open on start up, you can set it to "Maximise".

Go to the Macro tab, click New. In the "Action" column, select the drop down list and scroll down. If you want a particular form to open, select "openform" - at the bottom of the screen click in "Form Name" and select the form you want. Now click in the next Action line and from the drop down box select "maximise".

Save the Macro and call it "AutoExec". When you start up the database, this macro will run and maximise the form. PLay around with this and see if does what you want.

Hopefully this will help. Sorry if it doesn't

Chubbychap

 

[chubbychap]

One more thing.,....

Alternatively, if you are already in the database and need to go to the maximised form from a different location, you could create a macro in the similar way as mentioned before and create a button in a suitable location and link the macro to the button - thus the form will be opened and maximised.

Cheers

Chubbychap

 

[dk]

Also, you could right click your form in design view and choose Built Event (you may have to choose Code Builder as well). Place this code in your form code module:-

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

 

[Steve Jukes]

Thankyou both works fine. Just hwta I wanted.

Steve Jukes