Looking for an event

[Guest]

I have a form that when it opens, uses the On Open event to set InsideHeight
and InsideWidth. The form has a button to open a report.

When the report is displayed, the user may decide to maximise the report.
When they close the report and return to the form, the form is also now
maximised.

I thought I could use the On Activate event to reset the height and width
but it does not fire on closing the report. I suspect there is not an event
I can use. Can anyone confirm if this is right?

 

[Guest]

NevilleT,

Try using the OnClose event of your report.

Place the following code:

Docmd.Restore

 

[Guest]

Thanks. A bit of lateral thinking solved the problem.