Form opening gigantic!

[BrookieOU]

I have a form that I am using as a home page that has a command button on it
to open up another form that is a project list. When I click the command
button to open up the Project List the form is popping up (not opening as a
tab) and it is gigantic! Way larger than the information contained in the
form (I have to drag it over just to be able to get to the "x" to close it).
When I open up the Project List from the navigation bar it opens in the tab
view and not gigantic. Anyone know how to fix this on the command button? I
am using a simple Open Form command On Click for the command button.

Thanks!

 

[Jerry Whittle]

On the form itself put the following in the On Open event of the form:
DoCmd.Maximize

In the On Close event put:
DoCmd.Restore

This should open the form up rather large still; however, it should fit
where you can see the X and everything else on the form.

If you want to fine tune the window size, you could put the following on the
On Open event of the form:
DoCmd.MoveSize 1, 1, 14500, 9000

You'll need to mess with the numbers to get things right.