Hiding navigation pane in Access 2007

When I run a report in my 2007 application the navigation pane appears, and
the report is enclosed in a tabbed screen. The ribbon is then in print
preview mode. If the end user clicks on the navigation pane close button
manually it does close, but the ribbon then goes to database programming
mode, with tabs for General, Design, etc. I would not want my end users to
be able to see any of this (ribbon or navigation pane) except the print
preview ribbon.

I've tried the code that has been around for a long time that sets the
database property StartupShowDBWindow to false in my open code, but this
seems to have no effect.

Is there some VBA code that will completely hide the navigation pane and any
database programming features from the end user?

Bill

See here for tips on how to handle the ribbon:

http://www.access-freak.com/tutorials.html#Tutorial05

HTH
Damon

"wmdmurphy" wrote in message
.. .
When I run a report in my 2007 application the navigation pane appears,
and the report is enclosed in a tabbed screen. The ribbon is then in
print preview mode. If the end user clicks on the navigation pane close
button manually it does close, but the ribbon then goes to database
programming mode, with tabs for General, Design, etc. I would not want my
end users to be able to see any of this (ribbon or navigation pane) except
the print preview ribbon.

I've tried the code that has been around for a long time that sets the
database property StartupShowDBWindow to false in my open code, but this
seems to have no effect.

Is there some VBA code that will completely hide the navigation pane and
any database programming features from the end user?

Bill