How to: Hide the Ribbon When Access Starts
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 in order 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="https://schemas.microsoft.com/office/2006/01/CustomUI"> <ribbon startFromScratch="true"/></CustomUI> |
Applying a Custom Ribbon When Access Starts
To apply a custom ribbon so that it is available when the application starts, use the following procedure:
Follow the process described previously to make the customized ribbon available to the application.
Close and then restart the application.
Click the Microsoft Office Button and then click Access Options.
Click the Current Database option and then, in the Ribbon and Toolbar Options section, click the Ribbon Name list and select HideTheRibbon.
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.