MS access 2000 - I have a situation where I print letters and then the number 10 envelopes that they are mailed in. The problem comes up in that the application prints all of the pages properly and when it goes to print the envelope report the page size assigned to the envelop report changes from from Number 10 Envelope back to 8.5 by 11.
I have used the page setup for the envelop report to make sure that the page paer size is envelop #10 but it keep changing back to 8.5 by 11.
I need some VBA code that will run from an event before the envelop report prints and sets the page setup- paper size for the report to number 10 envelope. Is there another way to print envelops that will guarantee they print correctly. Also, these envelopes have to print to the prnter in vertical format. Therefore the report form displays the fields vertically on the report design page.
I appreciate any guidance you can give me