Using DoCMD.Showtoolbar

[jeffhanner]

I have a form with a button called Print Preview that opens a selected report in the Print Preview mode. For a particular User, I use DoCmd.Showtoolbar "Ribbon", actoolbarno in the login. Upon click on the Print Preview button the event sets the actoolbaryes. This results in only the Print Preview Group showing. When I exit the preview I want to go back to actoolbarno, however the events that I've tried on the form and button to include the "no" command only result in the all groups showing. I'm trying to find where to put the "no" command so that it hides the ribbon after the report is finished.



Any help would be appreciated.

[June7]

Did you try code in report Close event?

[isladogs]

As June indicated, use the Report_Close event
If you want to see this in practice, have a look at my example app Control Application Interface (isladogs.co.uk)

[jeffhanner]

What you suggested worked properly. I was trying events on the form to select reports, not the reports themselves.


Thank you.