Form keeps coming up maximized

[RSW]

I am building a database with one main form that, when a particular button is clicked, is supposed to pop up in a new window a subform about a third of the screen size.

The form keeps popping up maximized, covering everything else on the screen up, with lots of unused space. I'm sure it's simple to lock down a form to some particular size, but the instructions I am finding are:

Open a form in Form view (Form view: A window that displays a form to show or accept data. Form view is the primary means of adding and modifying data in tables. You can also change the design of a form in this view.) or a report in Print Preview.
Size the form or report by dragging the borders of the window.
Click Save on the toolbar.
Note If the AutoResize property is set to Yes, Microsoft Access automatically sizes the form or report to display complete records. To set the form or report window to the size you want, make sure the AutoResize property is set to No. The AutoResize property for a report is not available in Microsoft Access 2000 or earlier.

AutoResize is off. I keep changing the window size in Design Mode to the size I want, and saving. It then comes up that size for a while...but then eventually starts coming up full screen again (I can't figure out what exactly triggers the change). Does anyone know what in the world I am missing??

Thanks in advance

 

[boblarson]

You don't happen to have DoCmd.Maximize somewhere in the On Open or On Load event, do you?

 

[RSW]

Nope--not only does nothing show for those events in the Properties, but there's really nothing at all in the overall code for the form.

 

[missinglinq]

Is the main form maximized? If I remember correctly, when one form is maximized, all subsequent forms, regardless of how they're individually set up, will open maximized. I think this is one reason (maybe) why subforms actually open before the main form. On your popup form, in the OnOpen or OnLoad event (I forget which) try Me.Restore.

 

[Mike375]

Is your data base window maximised or in that medium size.

 

[RSW]

Is the main form maximized? If I remember correctly, when one form is maximized, all subsequent forms, regardless of how they're individually set up, will open maximized. I think this is one reason (maybe) why subforms actually open before the main form. On your popup form, in the OnOpen or OnLoad event (I forget which) try Me.Restore.

Thanks...I did have the main form maximized...I had no idea that would affect subsequent forms! I solved my problem by taking out the Maximize...BUT before that, I tried the Me.Restore 's, but VBA didn't seem to like them at all...any idea why?

 

[bbulla]

Try docmd.restore