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 Chris Miller 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
Nov 3, 2004
3
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