15. Sample database RibbonState (Zip Archiv 93 KB).


This sample shows how to identify the Ribbon state, whether it is maximized or on auto-hide and how to set the state by VBA.

Many thanks to Sascha Trowitzsch:


In Access 2010 you can change the Ribbon state with:

   CommandBars.ExecuteMso "MinimizeRibbon"

Ensure that the data base is stored in a trusted location before you start it.