Form Size

[frank]

Is there a process to keep a form at it's designed size.
When I use a form with a button that displays a report the
report opens to a maximum size. But when I return to the
form it displays in a maximum size also. Is there away to
stop the form displaying in a maximum size.

 

[JohnR]

On the reports Close Event add DoCmd.Restore this will
return the form to normal size.

 

[Greg Kraushaar]

This can have unintended consequences.
What if the user is going from one Max report to another?

I use doCmd.Restore/Maximise
or their RunCommand equivalents
in the Onactivate event.

Think Objects
The form/report knows how big it should be.
It shouldn't know or care how big anything else is

If you want to get real picky, you can put
On Error resume Next 'In case its maximised
RunCommand accmdSizeToFitWindow

In the Forms Resize event
(Check exact syntax I'm flying from memory & there are a few very
similar constants)

This works particularly well on Sizeable continuous forms.
Try it. You'll like it.

HTH GregK