VBA code - Show/Hide Ribbon

Question

I have recently updated an Access database to Access 2016. In the previous version (2003 mdb) I had some VBA code that showed or hid the menus/toolbars on request from a command button. Does anyone have some code that would do the same for the Ribbon in Access 2016?

Thanks.

Answer 1

There are different ways to do this.  Personally, i like to create a USysRibbons table and create a blank ribbon and set it as the application ribbon.  This way (i) i can easy hide the default ribbon, (ii) i can create my own custom ribbons for my applications (for printing, exporting, ...).

Using vba you could do

DoCmd.ShowToolbar "Ribbon", acToolbarNo

Then to show it again you'd do

DoCmd.ShowToolbar "Ribbon", acToolbarYes

Answer 2

There are different ways to do this.  Personally, i like to create a USysRibbons table and create a blank ribbon and set it as the application ribbon.  This way (i) i can easy hide the default ribbon, (ii) i can create my own custom ribbons for my applications (for printing, exporting, ...).

Using vba you could do

DoCmd.ShowToolbar "Ribbon", acToolbarNo

Then to show it again you'd do

DoCmd.ShowToolbar "Ribbon", acToolbarYes

Thank you. That works perfectly.