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

Posted on 2011-10-19
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
    LVL 56

    Expert Comment

    by:Jim Dettman (Microsoft MVP/ EE MVE)

     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 56

    Accepted Solution

    FYI, this site:

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


    Author Closing Comment


    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

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    This isn't a frequent question on EE. I must have seen it three or four times (among several thousand questions). However, I use this trick quite often, most frequently as a delayed Current event. A form does not expose it's calculation dependenc…
    Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
    Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
    What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

    728 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

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now