MS Access 2007--Hide ribbon but not the Quick Access Toolbar
Posted on 2011-10-19
I'm trying to hide the ribbon on my database without hiding the Quick Access Toolbar and the Office Button. So far I've tried the following.
1. I deselected the Allow Full Menus option under the Ribbon and Toolbar Options. This hides all tabs except the Home menu, which I would also like to hide, and leaves the QAT and Office Button visible.
2. I added "DoCmd.ShowToolbar "Ribbon", acToolbarNo" to the On Load event of my form. This however hides everything (Ribbon, QAT, and Office Button).
Any suggestions are appreciated.