IT Services & Technology Solution Services

IT Services YittBox
Create an account and receive a discount code for any future services!
Get Discount Code Now
Access – Minimize/Maximize Navigation Pane/Shutter Bar Question
                                        Ever wanted to minimize/close the Navigation Pane/Shutter Bar? Not hide it completely, just make it minimize/close/collapse. 
Please share any code you have for this.
                                    
  • 2

  • 2

Answers (2)

FMalik October 16, 2019
Welcome to YittBox. Thanks for posting this question. 
To minimize the navigation pane, but not hide it completely, you can try this code:
     DoCmd.NavigateTo "acNavigationCategoryObjectType": DoCmd.Minimize
 *
 *
 *
 
December 30, 2021
If you want to hide navigation pane, use the following VBA:

DoCmd.NavigateTo "acNavigationCategoryObjectType"              'This selects the navigation pane - if already hidden, it will open it
DoCmd.RunCommand acCmdWindowHide              'This hides the navigation pane

Alternatively, you can also do the following VBA:

DoCmd.SelectObject acModule, , True               'This selects the navigation pane - if already hidden, it will open it
DoCmd.RunCommand acCmdWindowHide            'This hides the navigation pane

Please note, this will produce an error if you are using the Runtime version of Access (since the navigation pane is disabled). To work around this, you would have to check the SysCmd(acSysCmdRuntime); something like this:

If SysCmd(acSysCmdRuntime) = False Then
    DoCmd.SelectObject acModule, , True
    DoCmd.RunCommand acCmdWindowHide
End If
 *
 *
 *
 

Leave a Reply

Your email address will not be published. Required fields are marked

 *
 *
 *
 
 
Let’s Work together

Start your Project

Loading