<div>
Is this for development purposes?<br />
<br />
Ideally, you don't want users to have direct access to any raw database objects.<br />
The users only interaction with database objects should be done through forms. <br />
<br />
Jeff
</div>


Is this for development purposes?

Ideally, you don't want users to have direct access to any raw database objects.
The users only interaction with database objects should be done through forms.

Jeff

<div>
<div class="content wysiwyg-content">
I've searched all over the web and couldn't find anything on this. &nbsp;I would like to &quot;collapse&quot; the Navigation Pane on a form load event. &nbsp;<br />
<br />
I could easily hide the navigation pane with 
<pre><code id="code-10-26386910-1">DoCmd.RunCommand acCmdWindowHide</code></pre>
, but I don' want to hide it. &nbsp;I only need to collapse it. &nbsp;Thanks for any suggestions!
</div>
</div>


I've searched all over the web and couldn't find anything on this.  I would like to "collapse" the Navigation Pane on a form load event.  

I could easily hide the navigation pane with (CODE), but I don' want to hide it.  I only need to collapse it.  Thanks for any suggestions!

VBA to collapse navigation pane in Access 2007

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.