Print dialog box available to users

[Guest]

I created a custom toolbar in Access 2003. I want the users to see the built
in print setup dialog box so that they can choose No of copies, range etc;
but the print button just sends the report straight to the printer. Why is
this? I have even tried coding in Sendkeys (ctrl and P), but that sends the
report straight to the printer as well.

Yet when I use the Print option from the standard File pull down menu, the
dialog box displays. Can anyone advise?

 

[Allen Browne]

After you OpenReport in preview, try:
RunCommand acCmdPrint

 

[Guest]

Thanks, that seemed to do the trick.
Now, when a report is in print preview mode, the user clicks the print
button on the custom toolbar and runs the following code:

Function fnPrint()
On Error Resume Next
Dim rptCurrentReport As Report
Set rptCurrentReport = Screen.ActiveReport
DoCmd.OpenReport rptCurrentReport.Name, acViewPreview, acViewNormal, , ,
acWindowNormal
RunCommand acCmdPrint
End Function

--
Regards
Shirley

After you OpenReport in preview, try:
RunCommand acCmdPrint