Hi, here's one more dumb question
how can I hide the menu and toolbar on the print preview window?, I just
want to be able to see the report.
regards
It's not necessary to cross post to so many newsgroups. The Report
newsgroup would have been sufficient.
The following in the report's Open event will hide the Menu bar and
Print Preview tool bar.
DoCmd.ShowToolbar "Print Preview", acToolbarNo
DoCmd.ShowToolbar "Menu Bar", acToolbarNo
Then Code the Report's Close event:
DoCmd.ShowToolbar "Print Preview", acToolbarWhereApprop
DoCmd.ShowToolbar "Menu Bar", acToolbarWhereApprop
But how are you going to then close the report without completely
shutting Access down?
I would suggest you either
1) not show just the Print Preview tool bar and leave the Menu bar, or
create a new Menu bar or Tool bar with just a Close button so that you
can close the report without exiting Access.
or..
2) Open the report in Dialog from a command button on a form using:
Docmd.OpenReport "ReportName",acViewPreview, , , acDialog
The second choice will only have a close (X) button to close the
report.
