Access 2007 Ribbon Hide/Show

  • Thread starter Thread starter SJ
  • Start date Start date
S

SJ

I hide the ribbon on startup for an App. However, I'd like to show the
ribbon when opening a report in printpreview mode to give the user the
opportunity to navigate and print and hide the ribbon when finished with the
printpreview.
 
In the report's Open event:

DoCmd.ShowToolbar "Ribbon", acToolbarYes

To hide it, in the report's Close event:

DoCmd.ShowToolbar "Ribbon", acToolbarNo
 
Back
Top