Toolbars in Report

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
 
M

Marshall Barton

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.
 
T

Tony Williams

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Template location changes from user to user 0
Incorporating the User Profile location into a document template path 1
Create own tool bar Mac 2015 0
Wrapping and Anchors 0
Blank Page After Envelope-Label Wizard 5
Add-Ins for Outlook (Mac) ? 0
Can I edit macro buttons on the quick access toolbar in excel? 0
Autocorrection pecularity 1

Top