How to: Hide the Ribbon When Access Starts

Access Developer Reference

By default, Microsoft Office Access 2007 does not provide a method for hiding the Ribbon. This topic describes how to load a customized ribbon that hides all of the built-in tabs.

To load the customized ribbon when Access starts, you should store its settings in a table named USysRibbons.

The USysRibbons table must be created using specific column names in order for the Ribbon customizations to be implemented. The following table describes the settings to use when creating the USysRibbons table.

Column Name Data Type Description
RibbonName Text Contains the name of the custom ribbon to be associated with this customization.
RibbonXML Memo Contains the Ribbon Extensibility XML (RibbonX) that defines the Ribbon customization.

The following table describes the Ribbon customization settings to store in the USysRibbons table.

Column Name Value
RibbonName HideTheRibbon
RibbonXML <CustomUI xmlns=""> <ribbon startFromScratch="true"/></CustomUI>

Applying the Customized Ribbon When Access Starts

To implement a custom UI so that it is available when the application starts, do the following:

  1. Follow the process described previously to make the customized ribbon available to the application.
  2. Close and then restart the application.
  3. Click the Microsoft Office ButtonButton image and then click Access Options.
  4. Click the Current Database option and then, in the Ribbon and Toolbar Options section, click the Ribbon Name list and select HideTheRibbon.
  5. Close and restart the application.
Bb258192.vs_note(en-us,office.12).gif  Note
For more information about the Ribbon UI in other Office applications, see Overview of the Ribbon User Interface.