Ask What Printer

[EllieFant]

I will be creating a report that when printed I want to be able to choose what printer I print it too. How can I make the printer dialog box open up for that report alone.

The reason I need to do this is that the report will need to be printed in color - not everyone is mapped to a color printer, and those that are not mapped to the same one.

Thanks for any help you can offer.
Ellie
**Using Access 97 at work**
**Using Access 2000 at home**

lena.wood@starband.net

 

[BigHughie]

Ellefant,

I would open the report in print preview mode. This allows the user to check that the information fits on the page etc- and that it is the correct thing to print.

the code to do this would be something like:

DoCmd.OpenReport reportname, acViewPreview , , strcriteria

or you could use a macro containing an openreport action to open it in preview mode.

Then, To print the report use the Print option on the File menu, to choose the printer.

Hope that helps

Hugh

 

[EllieFant]

The people using the database would not even look at the preview of the report before they printed it. They will assume that I have put the report together to make it appear correctly.

Thanks for the help,
Ellie
**Using Access 97 at work**
**Using Access 2000 at home**

lena.wood@starband.net