Set different printer in a report

  • Thread starter Thread starter jimt
  • Start date Start date
J

jimt

I have a report using a that I would like to sent to one of two printers
based on a a field within the record read. A query is used as the data source
for the report and the printer control data is a Yes/No field. If the yes/no
field is "yes" I want to send the print out for the record to go to printer
"A" and if the value is "no" sent the record print out to printer "B". This
is a local DB and the two printer are attached to the PC containing the DB.

Is there a way to dynamically switch printers based on the record during the
running of the report? For example including a function on detail in the
report to set the printer. If so what are the command(s)?

Thanks
Jim T.
 
Jim

Which version of Access? Access 2007 has some limitations on using a
"designated" printer rather than the default printer.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
The DB is an Access-2000.

Thanks
Jim T

Jeff Boyce said:
Jim

Which version of Access? Access 2007 has some limitations on using a
"designated" printer rather than the default printer.

Regards

Jeff Boyce
Microsoft Office/Access MVP
Click to expand...
 
Back
Top