Code to open a report and display the print dialogue box

[Scott]

Hello-

I have a contol button on a form that I want to code to open a report
(rptReviews), then display the print dialogue box so that users can
select a printer. This report needs color, but most of my team has
their default printer set to our departments monochrome printer. Thus
i wanted to give them the option to run it to our color printer during
the print process.

Alternately, is there a way to code a button to drive a report to
print on the color printer on our network?

All ideas are appreciated-

Scott

[Tom van Stiphout]

On 16 Apr 2007 20:02:06 -0700, Scott <ss***@henryschein.comwrote:

The user can open this dialog by choosing File>Print or Ctrl+P.

If you want to code a "Print to the color printer" button, check out
the Printer object (Access 2002 and better).

-Tom.

>Hello-

I have a contol button on a form that I want to code to open a report
(rptReviews), then display the print dialogue box so that users can
select a printer. This report needs color, but most of my team has
their default printer set to our departments monochrome printer. Thus
i wanted to give them the option to run it to our color printer during
the print process.

Alternately, is there a way to code a button to drive a report to
print on the color printer on our network?

All ideas are appreciated-

Scott