Results 1 to 5 of 5
  1. #1
    MadTom's Avatar
    MadTom is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jun 2018
    Location
    CT and VT
    Posts
    206

    How do I hide menu?

    How do I hide the 2nd menu down in form view (File Home Tell me what you want to do) in VBA? I've searched and nothing seems to work.


    Thanks!

  2. #2
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    As far as I can tell, you cannot, unless you roll your own ribbon. The modification might be
    <tab idQ="HelpTab" visible="false"/>

    or I guess just don't include that tab. I'm not sure if that search bar is a member of the backstage or what it belongs to.
    Last edited by Micron; 11-25-2020 at 03:46 PM. Reason: added info
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  3. #3
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    As Micron indicated, create your own custom ribbon.
    Use this code in a USysRibbons table to just show the full File & Home ribbons:

    Code:
    <customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui">  <ribbon startFromScratch="true">
    <tabs>
       <tab idMso="TabHomeAccess" visible="true" />
    </tabs>
      </ribbon>
    </customUI>
    The result is:
    Click image for larger version. 

Name:	Capture.PNG 
Views:	20 
Size:	4.5 KB 
ID:	43503

    You can also remove the Home tab completely and some/all items from the File tab. Or you can remove the ribbon completely
    For more info, see http://www.mendipdatasystems.co.uk/i...y-2/4594571073
    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

  4. #4
    MadTom's Avatar
    MadTom is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jun 2018
    Location
    CT and VT
    Posts
    206
    Thank you for your comments! Sometimes I open my database in form view and the ribbon is there and sometimes it not?
    Mad-Tom

  5. #5
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Do you mean sometimes the ribbon is maximised and at other times it is minimised?

    Or do you mean sometimes it is hidden completely? That is only possible using VBA code
    If so, the ribbon will be hidden ALWAYS unless you use code to show it again!
    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 objects and menu bar from the users
    By Blancorn in forum Access
    Replies: 1
    Last Post: 04-10-2016, 06:08 PM
  2. Need Menu
    By mmaule in forum Access
    Replies: 7
    Last Post: 05-17-2014, 01:47 PM
  3. Replies: 1
    Last Post: 03-02-2014, 01:31 PM
  4. Menu with multiple sub menu's
    By Simtech76 in forum Forms
    Replies: 1
    Last Post: 04-30-2013, 02:30 PM
  5. Replies: 0
    Last Post: 09-25-2012, 09:16 AM

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