[Last Call] Learn how to a build a cloud-first strategyRegister Now


MS Access 2007--Hide ribbon but not the Quick Access Toolbar

Posted on 2011-10-19
Medium Priority
Last Modified: 2012-05-12
I'm trying to hide the ribbon on my database without hiding the Quick Access Toolbar and the Office Button.  So far I've tried the following.

1. I deselected the Allow Full Menus option under the Ribbon and Toolbar Options.  This hides all tabs except the Home menu, which I would also like to hide, and leaves the QAT and Office Button visible.

2. I added "DoCmd.ShowToolbar "Ribbon", acToolbarNo" to the On Load event of my form.  This however hides everything (Ribbon, QAT, and Office Button).

Any suggestions are appreciated.
Question by:giswest
  • 2
LVL 58
ID: 36993657

 You'll have to do a custom (blank) ribbon.  The quick access toolbar is part of the ribbion.

 Check out the following MSKB article:

  Customize the Ribbon

LVL 58

Accepted Solution

Jim Dettman (Microsoft MVP/ EE MVE) earned 2000 total points
ID: 36993686
FYI, this site:


 is one of the better ones around covering all topics dealing with the ribbon.


Author Closing Comment

ID: 37015068

Thank you for providing me with the direction I need to resolve this issue. The resources you provided will be most helpful.

Thanks again.

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

829 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question