Access 2007 keeps resizing my forms!

[Clut]

As the title suggests, access 2007 keeps resizing my forms to make them bigger than they should be.

I HAVE set the auto-resize property to NO, and I've also got the auto-centre property set to YES.

the centering seems to work, but I just can't get the forms to stay the right size.

Any help?

 

[JamesMcS]

I've had this problem too, but only where the main Access window was smaller than the form being displayed. Have you tried setting form.width and form.height?

 

[Trevor G]

As James is suggesting you could set this up with some VBA code when the form is opened. Go into design view then select the form properties then select Events and then On Open add this code, then play with the numbers till you get to where you want to be.

Private Sub Form_Open(Cancel As Integer)
Form.Width = 2500
Form.InsideHeight = 4500
End Sub

 

[JamesMcS]

Bit annoying that it has to be done but I don't know what the root cause is....

 

[boblarson]

Bit annoying that it has to be done but I don't know what the root cause is....

The root cause is shown here.

 

[JamesMcS]

Assumption makes an ass out of u and me eh? That was the first thing I changed when I moved to '07.... so annoying

And of course width and height would make jack difference if that option hadn't been changed anyway