Access 2007 – Hide the Navigation Pane / Shutter Bar

When working on a database in Access 2007 it may be useful to hide the Navigation Pane (Shutter bar) at the left hand side of the screen.

We can do this manually by changing the Navigation options in the Current Database properties within the Access options window. (Click the Microsoft Office Button and then click the Access Options button).

You may then disable the the Navigation Pane (for this database) by using the Enable Navigation Pane checkbox.

You can also hide and unhide the Navigation Pane at anytime by pressing the F11 key. (You could use the SendKeys code from my other post here and replace F1 with F11 to do this in VBA code).

However, it may be useful to remove the Navigation Pane entirely.

We can do this by using the following macro:

1) Start a new macro.

2) In the “Action” column select “SendCommand”

3) In the “Arguments” column select “WindowHide”

Running this macro when your database first loads will now hide the navigation pane.

About these ads

15 Responses to “Access 2007 – Hide the Navigation Pane / Shutter Bar”


  1. 1 Peter LeNeau October 28, 2008 at 2:35 pm

    In my version of Access 2007 I do not have an action labeled “sendcommand”. The action that works is “runcommand” with the argument of “windowhide”.

  2. 2 Carys August 26, 2009 at 1:23 pm

    How do I now get it back to work on it?

  3. 3 Lorne Booth February 19, 2010 at 8:20 pm

    I have 2 command buttons on a form that Show or Hide the Navigation Pane (i.e. the shutter bar on the left side of the Access 2007 window). They work nicely for me.

    The VBA behind the 2 command buttons is …

    Private Sub cmdShowNavigationPane_Click()
    DoCmd.SelectObject acTable, , True
    End Sub

    Private Sub cmdHideNavigationPane_Click()
    DoCmd.NavigateTo “acNavigationCategoryObjectType”
    DoCmd.RunCommand acCmdWindowHide
    End Sub

  4. 4 suresh April 21, 2010 at 3:28 pm

    Hi ,

    Very useful. Thank you very much for sharing
    keep up your good job

    Thanks

  5. 8 Andrew November 17, 2010 at 3:56 am

    Peter,

    Try using the line below. If you still get the message make sure the quotes around the object type are normal double-quotes.

    DoCmd.NavigateTo (“acNavigationCategoryObjectType”)

    Andrew

  6. 9 Jack Chang January 11, 2011 at 5:22 am

    Hi there,

    Greetings,
    Stumbled upon this website and had the same problem too with the line “DoCmd.NavigateTo (“acNavigationCategoryObjectType”)”
    with the error code Runtime error 2505, An expression in argument 1 has an invalid value.

    Any one has found a solution to it? Could it be a syntax thingy whereby the one posted is for 2003?

  7. 12 hafsa March 12, 2011 at 8:16 pm

    Hi,
    I can’t do what has been explained above. There is no ‘SendCommand’ option.
    Please help, I have a project to finish.
    Thanks.

  8. 13 midas November 9, 2011 at 6:47 am

    I used the drag to close the side navigation pane instead of F11 and it would not close all the way but I could not openit again either. How can I get it back open?


  1. 1 Access 2007 - Hide the Ribbon Bar « MoveFirst Weblog Trackback on September 10, 2008 at 4:05 pm
  2. 2 Navigation Pane Trackback on June 6, 2009 at 12:53 pm

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s




Blog Stats

  • 194,990 hits

Counter

ClustrMap


Follow

Get every new post delivered to your Inbox.

%d bloggers like this: