Access 2007 Ribbon Hide/Show

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

Arvin Meyer [MVP]

In the report's Open event:

DoCmd.ShowToolbar "Ribbon", acToolbarYes

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

DoCmd.ShowToolbar "Ribbon", acToolbarNo
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

quick access tool bar and the ribbon 2
Access 2007 Ribbon 1
Subform Datasheet Total Row 3
How to: Hide the Ribbon When Access Starts 2
Hide/Reveal ribbons with VBA 2
hidding group commands in ribbon and setting password with vb 1
Access 2007 : How to hide ribbon ? 1
Ribbon and Menu Bar 2

Top