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:
Ensure that the data base is stored in a trusted location before you start it.