Edit

Hide the ribbon when Access starts

  • Article

Applies to: Access 2013 | Office 2013

By default, Microsoft Access 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 for the ribbon customizations to be implemented.

The following table lists 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 lists the ribbon customization settings to store in the USysRibbons table.

Column name Value
RibbonName HideTheRibbon
RibbonXML <CustomUI xmlns="http://schemas.microsoft.com/office/2006/01/CustomUI"> <ribbon startFromScratch="true"/></CustomUI>

Apply a custom ribbon when Access starts

To apply a custom ribbon so that it is available when the application starts, use the following procedure:

  1. Follow the process described previously to make the customized ribbon available to the application.

  2. Close and then restart the application.

  3. Choose the Microsoft Office ButtonO12FileMenuButton_ZA10077102, and then choose Access Options.

  4. Choose the Current Database option and then, in the Ribbon and Toolbar Options section, choose the Ribbon Name list and select HideTheRibbon.

  5. Close and then restart the application.

Note

For more information about the ribbon UI in other Office applications, see Overview of the Office Fluent Ribbon.