Hi Rick
I can confirm that Access saves the NavPane Width property when it closes ready for the next time the file is opened.
I've also now attempted unsuccessfully to modify the NavPane Width using variations of the SetPropertyDAO code by Allen Browne.
I think you should abandon this idea and go for a much simpler idea - hide or minimise the navigation pane - both of which do work.Place thiscode in a standard module.
Code:
Public Function ShowNavigationPane()DoCmd.SelectObject acForm, , True
End Function
Public Function HideNavigationPane()DoCmd.NavigateTo "acNavigationCategoryObjectType"
DoCmd.RunCommand acCmdWindowHide
End Function
Public Function MinimizeNavigationPane()DoCmd.NavigateTo "acNavigationCategoryObjectType"
DoCmd.Minimize
End Function
Then just run e.g. MimimizeNavigationPane in the Form_Load event or on a button click
You can see this code in use in various example apps of mine. For example:
http://www.mendipdatasystems.co.uk/c...ace/4594365418
That also includes code you may find useful including:
a) minimize/maximize/hide the ribbon
b) hide/show the taskbar
c) hide/show the Access application window
I'd also recommend changing to overlapping windows as that gives far more control over the display
Finally its still good practice to split databases even if you are the only user.
This makes it easier to backup the data / recover from corruption / update the user interface (forms/reports/code etc ) without affecting your data ... etc
HTH