I have a report that prints labels based on order information. Currently, to do this, each page prints the Order and Line Item information for an order. My labels are 5 X 3.5 and there are 4 on a sheet.
Each time my user goes to print the label report, they must first go into the Printer Properties and change the "Pages per sheet" option to 4. This forces it to print 4 pages to one sheet and fits the labels well.
I have attempted to create the labels differently through the Label Wizard but due to the way I must extract the data, I cannot group the information and have it display properly and consistently.
Is there a way through VBA or the Report Properties to automatically set the Pages Per Sheet when the user decides to print to eliminate the tedious task of changing things in the Printer Properties?
Thanks for any assistance!
Each time my user goes to print the label report, they must first go into the Printer Properties and change the "Pages per sheet" option to 4. This forces it to print 4 pages to one sheet and fits the labels well.
I have attempted to create the labels differently through the Label Wizard but due to the way I must extract the data, I cannot group the information and have it display properly and consistently.
Is there a way through VBA or the Report Properties to automatically set the Pages Per Sheet when the user decides to print to eliminate the tedious task of changing things in the Printer Properties?
Thanks for any assistance!
