Maximise and Restore !!!!!

[WhizzkidWallace]

Hello clever people....

I have a switchboard which can call up various reports in Preview mode...nice. When I do though, they come up in a window, and I then maximise them to view the whole page width. Then when I close the report, my Switchboard is now full screen, and looks odd, so I then click the restore button.

Is there any way I can keep my Switchboard in a window, but open all reports Maximised.

I have put the 'docmd.maximize' command in the reports 'open' event, which cures half the problem, but how can I get the Switchboard to 'Restore' when I close the report.

Thanks

 

[daveUK]

On the Report Close event, type DoCmd.Minimize

HTH

 

[Rich]

DoCmd.Restore, in the close event of the Report, you'll have to a watch for unwanted side effects though

 

[dt01pqt]

Report.SetFocus
DoCmd.Maximize

....

SwitchBoard.SetFocus
DoCmd.Restore

 

[WhizzkidWallace]

Thanks

Thanks for that...