Results 1 to 2 of 2
  1. #1
    UT227 is offline Expert
    Windows 7 32bit Access 2013 32bit
    Join Date
    Feb 2016
    Posts
    581

    Hide the ribbon


    Is there a way to hide the ribbon when Access is opened? On my database, each user logs in. When a new user logs in, the ribbon appears. Is there a way to tell Access to hide the ribbon when it opens?

  2. #2
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,974
    Not at my computer at the moment but its easy enough to do if using A2010 or later.
    See the HideRibbon function in this example app http://www.mendipdatasystems.co.uk/c...ace/4594365418
    Run that function from an autoexec macro at start up.

    UPDATE: Back at my PC now:

    Code:
    Public Function HideRibbon()     
       DoCmd.ShowToolbar "Ribbon", acToolbarNo
    End Function
    NOTE: This also hides the QAT which makes printing reports tricky.
    I handle that by displaying the Print Preview ribbon when a report is opened and hiding the ribbon again when the report is closed.
    The example app includes an example showing how that's done
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

Please reply to this thread with any new information or opinions.

Similar Threads

  1. hide ribbon code error
    By Jen0dorf in forum Access
    Replies: 4
    Last Post: 12-03-2015, 07:10 AM
  2. Hide the Ribbon Hot Key
    By Paul H in forum Access
    Replies: 4
    Last Post: 10-07-2015, 12:48 PM
  3. Ribbon Hide
    By msaccessdev in forum Programming
    Replies: 2
    Last Post: 10-27-2014, 12:13 PM
  4. Open form only, hide the ribbon bar.
    By kcmiuser in forum Access
    Replies: 3
    Last Post: 05-22-2013, 02:04 PM
  5. Un-hide Ribbon
    By mattellenburg in forum Access
    Replies: 0
    Last Post: 12-08-2011, 02:08 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums