Ribbon is hidden only every other time when I open DB (need to always hide it)

[skydivetom]

Hello:



I have a fundamental question... upon opening a DB, I *always* want to hide the RIBBON. I have added 2 lines of code where the 1st line, apparently, does not hide the ribbon (thus, it is currently commented out). Alternatively, the 2nd line appears to be working; however, the hiding/displaying of the ribbon alternates each time when I open the DB.

Private Sub Form_Load()

    'DoCmd.ShowToolbar "Ribbon", acToolbarNo
    CommandBars.ExecuteMso "MinimizeRibbon"

End Sub

That is, ...
1. Open DB for the first time... the ribbon is hidden.
2. Open DB for the second time... ribbon is displayed.
3. Open DB for the third time... the ribbon is hidden again.
etc. etc.

What code should be added/modified so that I always hide the ribbon and/or toolbar (unless I open the DB using the by-pass key)?

Thank you,
Tom

P.S. And, oh by the way, I only want the hiding of the ribbon/toolbar be applied to this particular DB... not every time I open up any other ACCDB file. That is, I just noticed that the hiding of the ribbon (this sample file) also hides the ribbon on a completely different DB. I don't want that!

[isladogs]

The second line acts as a toggle. It minimizes the ribbon if its full height and vice versa...so no use to you.

Using the commented out line works every time for me. Or at least it minimizes the ribbon so only the 3 menu items are visible.
Or did you want to hide those as well?
Anyway, try removing your Customized Toolbar from the Menu Bar in Access Options. It appears to be superfluous

[skydivetom]

isladogs -- thank you for the feedback. Copy on the toggle... I deleted that line.

WRT to the minimized ribbon, I was hoping that I won't see "File | Add-Ins | Tell me what... " either.

Also, as suggested, I set the menu bar = "(default)" under the Navigation Option. Still, this particular DB still displays the ribbon (well, only the minimized version).

Any idea as to how I could completely hide it for this ACCDB only?

Thanks,
Tom

[isladogs]

Easy to do. You were almost there ...

You either need to create your own blank ribbon using "StartFromScratch=True"
OR you need to ENABLE Allow Built-In Toolbars in Access Options



Doing that will allow the line DoCmd.ShowToolbar "Ribbon", acToolbarNo to completely hide the ribbon

I've included my module modRibbon which includes these items HideRibbon, ShowRibbon, ToggleRibbonState & IsRibbonMinimized.
You may find them useful

If you are going to do any serious development work such as hiding parts of the application interface, I recommend you read two of my web articles and look at the accompanying example apps:
Control Application Interface (isladogs.co.uk)
Improve Access Security 2 (isladogs.co.uk)

[skydivetom]

Colin:

Awesome!!! That works beautifully!

Thank you for sending the version that also includes your module... 'very helpful.

Also, I appreciate the link to the 2 web articles of yours. 'Much obliged.

Cheers,
Tom

[isladogs]

For info, the Allow Built-In Toolbars option is normally not available.
It only appears when you create that property (as you did to use your customised menu).

See this article for more info: AllowBuiltInToolbars Property (microsoft.com)