Access 2003 Report Printing

[Sarah Meyer]

I have a report that is a label formatted to print to a Dymo Labelwriter. Unfortunately, we have different label printers at different workstations and when Access can't find the particular printer specified for the report, it reformats the page to 8.5x11in so that if you tell it which printer to use without reformatting the page size, you'll get a zillion blank labels. Is it possible in Access 2003 to say "If Workstation A, then print Dymo A. If Workstation B, then print Dymo B. etc.?" Is that even the best solution to my problem?

[jimatqsi]

My solution for this in the past has been to have two separate reports, each programmed for the proper printer. Then the if/then test decides which report to run. Not elegant, by any means, but it has worked for me.

Jim