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.