Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Print Option Disabled

Status
Not open for further replies.

careysc

Programmer
Joined
Nov 3, 2004
Messages
3
Location
US
What do I need to do to enable or disable the Print option in the File Menu when displaying a report in Preview mode.

Here's what is happening. I am displaying a report with the following code:

DoCmd.OpenReport "rptPictures", acViewPreview, , strWhere

When I go to the File Menu and try to print the report, the Print option is disabled. Now the curious thing is that I can still right-click on the report and select the Print Option from there. This is the only report in the application that has the Print disabled, so I assume that it is something that has been set up specifically for this report, but I haven't found the spot where I can enable it again.

Any help is appreciated.

Thanks,
Carey
 
Thanks Tom,

It worked like a charm.

I added the following lines into the Open logic of the report and the Print option was enabled:

Dim CBarTool As CommandBar

Set CBarTool = CommandBars("File")
CBarTool.Controls("Print...").Enabled = True


Thanks Again,
Carey
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top