full size form?

[chris davies]

I have looked but can't seem to find a method to make my form open at full size. Is this possible, what may I be missing here. Any and all answers gratefully recieved. thank you.

 

[boblarson]

In the form's On Open Event you can put:

DoCmd.Maximize

And in the close event use

DoCmd.Restore

if you don't want everything to stay maximized.

 

[chris davies]

errm, put DoCmd.Maximize in the on open event, now the form refuses to open arrgh, thank god for back ups lol

 

[boblarson]

errm, put DoCmd.Maximize in the on open event, now the form refuses to open arrgh, thank god for back ups lol

It has nothing to do with the code. You don't have to open the form to get to the code. Open a module and navigate to the code on the left in the explorer window in the VBA IDE.

I use DoCmd.Maximize on all of my forms when opening them, so something else is up.

 

[boblarson]

It has nothing to do with the code. You don't have to open the form to get to the code. Open a module and navigate to the code on the left in the explorer window in the VBA IDE.

I use DoCmd.Maximize on all of my forms when opening them, so something else is up.

Also, if you post the db I could troubleshoot what the real problem is.

 

[chris davies]

Sorry to take so long to reply, have fixed my form. Where exactly do I put the DoCmd.Maximize command? I must have misundertood originally because I tried to put it in the op open event via the form's properties. The Db has grown somewhat in size and is now too large to upload

 

[boblarson]

 

[chris davies]

Hi there,
I found the solution, by creating a new macro and selecting maximise and then naming the macro autoexec, then by calling autoexec on the onload event, which I finally found by right clicking on various parts of the form. The most irksome part was finding where the onload event was situated.