Toolbars in Report

  • Thread starter Thread starter Tony Williams
  • Start date Start date
T

Tony Williams

How do I open a report so that there are no toolbars showing when it opens.
I have Docmd.Maximise in the OnOpen so it uses the available screen space
but I want to get rid of the toolbars to create extra space.
Thanks
Tony
 
Tony said:
How do I open a report so that there are no toolbars showing when it opens.
I have Docmd.Maximise in the OnOpen so it uses the available screen space
but I want to get rid of the toolbars to create extra space.
Click to expand...


You can show/hide menu/tool bars:

DoCmd.ShowToolbar "Menu Bar", acToolbarYes

Use the report's Activate event to hide them and the Close
event to show them.
 
Thanks Marshall
Tony
Marshall Barton said:
You can show/hide menu/tool bars:

DoCmd.ShowToolbar "Menu Bar", acToolbarYes

Use the report's Activate event to hide them and the Close
event to show them.
Click to expand...
 
Back
Top