asked on 3/9/2019

Can you hide the ribbon and keep the Tabs in Access 2010?

it is possible to hide the Ribbon and keep the tabs? I know how to hide the ribbon. See attached

Microsoft Access

Last Comment

Bill Prew

3/10/2019

Bill Prew

3/9/2019

Have you tried the small "caret" at the far right of the ribbon, that does what you are describing.

»bp

J.R. Sitman

3/9/2019

ASKER

I do know that. I was just wondering if there's a way to code it so that users didn't have to do it

ASKER CERTIFIED SOLUTION

Bill Prew

3/9/2019

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

J.R. Sitman

3/9/2019

ASKER

Put that in the onload event

Bill Prew

3/9/2019

Right.

»bp

J.R. Sitman

3/9/2019

ASKER

Thanks

Eirman

3/9/2019

I use this code on a form button to toggle (hide/show) the ribbon and the Objects on the left.
The tabs always remain visible.
You can experiment by 'commenting' out sections of the code.

Private Sub CommandHIDE_Click()
    Static IsHidden As Boolean

    If IsHidden Then
        DoCmd.ShowToolbar "Ribbon", acToolbarYes
        DoCmd.SelectObject acTable, , True
        IsHidden = False
    Else
        DoCmd.ShowToolbar "Ribbon", acToolbarNo
        DoCmd.NavigateTo "acNavigationCategoryObjectType"
        DoCmd.RunCommand acCmdWindowHide
        IsHidden = True
    End If
End Sub

Open in new window

J.R. Sitman

3/9/2019

ASKER

@Bill. did not work. The ribbon and tabs are hidden.

Fabrice Lambert

3/10/2019

I do not recommend enforcing the ribbon's visibility.
Some users like it minimized, some like it maximized.
Thus, your application should not rely on the ribbon's visibility, neither assumes it is minimized or maximized, because there are no way to check the ribbon's state programatically.

If you are speaking about how access object are displayed (tabs or Windows), you can't interract with these programatically either.

J.R. Sitman

3/10/2019

ASKER

Good point

J.R. Sitman

3/10/2019

ASKER

@Bill. Correction, it did work. I had to go to the Current Database options and set it to "display document tabs"

Thanks

J.R. Sitman

3/10/2019

ASKER

Thanks

Bill Prew

3/10/2019

Welcome.

»bp