By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,224 Members | 1,630 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,224 IT Pros & Developers. It's quick & easy.

Access 2003 Report Printing

P: 1
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?
Nov 2 '11 #1
Share this Question
Share on Google+
1 Reply

Expert 100+
P: 1,221
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.

Nov 4 '11 #2

Post your reply

Sign in to post your reply or Sign up for a free account.