Solved Report ribbon

[PaquettePaul]

Whenever I print preview a report, the report ribbon appears and then disappears when I close the report. How do I prevent the display of the report ribbon in this circumstance? Is this in a report property?

 

[theDBguy]

How exactly are you opening the report?

 

[PaquettePaul]

DoCmd.OpenReport ReportName, acViewPreview

 

[theDBguy]

DoCmd.OpenReport ReportName, acViewPreview

Try adding this line before that.

DoCmd.ShowToolbar "Ribbon", acToolbarNo

 

[PaquettePaul]

Thank you

 

[arnelgp]

you can also make the report as Pop-up (design view->property->other->pop up: yes).

 

[theDBguy]

Thank you

Don't forget to turn it back on, in case you need the ribbon later.

 

[PaquettePaul]

I decided to turn the ribbon off when I opened the main menu form and turn the ribbon back on when I close it. Easier that way.

 

[theDBguy]

I decided to turn the ribbon off when I opened the main menu form and turn the ribbon back on when I close it. Easier that way.

Good luck with your project.