X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Reply to this topicStart new topic
> How To Hide Qat From Ms Access Ribbon, Access 2016    
post May 7 2019, 12:23 PM

Posts: 93
Joined: 9-April 19


does anybody knows how can I hide Quick Access Toolbar from MS Access Ribbon? I suppose it is possible through XML but don't know how.

Attached File  QAT.PNG ( 564bytes )Number of downloads: 8

Go to the top of the page
post May 7 2019, 01:20 PM

UA Moderator
Posts: 77,730
Joined: 19-June 07
From: SunnySandyEggo

Hi. I'm not sure if it can be hidden but check out here.

Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
post May 7 2019, 01:32 PM

UtterAccess VIP
Posts: 2,247
Joined: 4-June 18
From: Somerset, UK

Just to confirm what DBG indicated.
You can't hide the QAT unless you hide the entire ribbon.
If you want to hide/show the ribbon and QAT, use the following code in a standard module

Option Compare Database
Option Explicit

Public Function HideRibbon()
    'could run at startup using Autoexec
    'however this also hides the QAT which makes printing reports tricky
     DoCmd.ShowToolbar "Ribbon", acToolbarNo
   '  DoCmd.ShowToolbar "PrintReport", acToolbarYes
End Function

Public Function ShowRibbon()
    'use when opening a report to display print preview ribbon
     DoCmd.ShowToolbar "Ribbon", acToolbarYes
End Function

Public Function ToggleRibbonState()

'hide ribbon if visible & vice versa
    CommandBars.ExecuteMso "MinimizeRibbon"
End Function

Public Function IsRibbonMinimized() As Boolean
    'Result: 0=normal (maximized), -1=autohide (minimized)

    IsRibbonMinimized = (CommandBars("Ribbon").Controls(1).Height < 100)
   ' Debug.Print IsRibbonMinimized
End Function

You can see an example of this and other ways of managing the application interface at My Website

Colin (Mendip Data Systems)
Website, email
Go to the top of the page

Custom Search

RSSSearch   Top   Lo-Fi    8th April 2020 - 09:29 AM