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

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

"Jomark" <(E-Mail Removed)> wrote in message
news:367580FB-FF48-463B-863C-(E-Mail Removed)...
>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

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.)

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Jomark" <(E-Mail Removed)> wrote in message
news:367580FB-FF48-463B-863C-(E-Mail Removed)...
>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

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

"Allen Browne" wrote:

> 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.)
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "Jomark" <(E-Mail Removed)> wrote in message
> news:367580FB-FF48-463B-863C-(E-Mail Removed)...
> >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
>
>