Evil Expanding Form

[TheSearcher]

I have a form that is 3 inches high by 3 inches wide. However, when the form opens in run time it expands to cover almost the entire screen. I want it to remain 3 x 3. The form opens over a form that is maximized. Here is some additional info:
Pop Up = Yes
Modal = Yes
Auto Resize = No
Fit to Screen = No
Scroll Bars = Neither
I also tried:
Docmd.Restore in the on Load and on open events (doesn’t work)
File -> Options -> Current Database – Changed Document Window Options from Tabbed Documents to Overlapping Windows (Doesn’t work)

How can I stop this form from expanding?????

Thanks,
TS

 

[isladogs]

Does it behave itself when the other form isn't open?

 

[Tieval]

In the open event you could use DoCmd.MoveSize to set the size and position of the form.

 

[TheSearcher]

Ridders - No it does not. It only looks the way I want (3x3) in design mode.

 

[TheSearcher]

Tieval - DoCmd.MoveSize does work. But - why do I need to resort to code? Shouldn't the properties of the form be able to control this?

 

[isladogs]

Re-open in Design View and click the restore button at the top right
Now reduce the size of the 'containing window' to fit your form dimensions.
Save & close
Reopen normally & I believe all will look perfect to you

 

[TheSearcher]

Ridders - It worked! Not sure why - but it worked. Thanks!

 

[isladogs]

It works because Access sizes the form to fit the container window ignoring the dimensions you set. Stupid but true!