close Print Preview causes form to open in full window

[Jomark]

I have a database with a main menu form that closes when a report is opened
in print preview. The report opens in small view and clicking on full view
the only way to then close the report is by pressing the close print preview
button.

I have code in the report that when it is closed the main menu form opens.
Clickng on the close button on the report when it is still small returns the
main menu form in its normal size. However when clicking on the close print
preview button the main menu form opens in full screen view.

is there any way to prevent this from happening so that the main menu form
opens in its normal size.

I am using Access 2007

 

[Alex Dybenko]

Hi,
Perhaps you need to add:
docmd.Restore
In report close event

Also you can try this approach:
http://www.pointltd.com/Downloads/Details.asp?dlID=45
"the sample shows how to open MS Access report and make it window size match
access main window, while window is not maximized actually"

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

 

[Allen Browne]

Use a macro in the form's Activate event.
The Restore action will put the form back in its own window.

(This assumes you have set up the database for windows, not tabbed
documents.)

 

[Jomark]

Thanks Alex and Allen for your responses.
Very much appreciated.
It works