My company is finally switching to office 2010 and I'm in charge of testing all of our macros and reports.
I've got all the data working, but now I'm having a formatting problem. This is a computer that is used only for testing, so there are no printers installed on it. The report is designed to use all of 10.5 inches in landscape. The print margins (in page setup) are coming up as 0.25 on the left and 0.583 on the right. When I try to adjust the right one back to 0.25, as soon as I tab out of the field, it goes back to .583. Additionally, even though it's set to landscape, it comes out portrait (and it looks like it's been stretched). It has always printed them out as .snp files, we then email these reports to senior managers (their pants are very fancy and so the reports have to look good)
Things that I have tried:
1. changing the paper type around and playing the the margins, but it only makes the stretching worse when it flips to portrait
2. I even tried changing the design of the form to cut off .333 of an inch, but then it still prints 2x the number of pages, but that next page is just blank.
3. Searching the internets for an answer
ANY suggestions would be GREATLY appreciated!!
I've got all the data working, but now I'm having a formatting problem. This is a computer that is used only for testing, so there are no printers installed on it. The report is designed to use all of 10.5 inches in landscape. The print margins (in page setup) are coming up as 0.25 on the left and 0.583 on the right. When I try to adjust the right one back to 0.25, as soon as I tab out of the field, it goes back to .583. Additionally, even though it's set to landscape, it comes out portrait (and it looks like it's been stretched). It has always printed them out as .snp files, we then email these reports to senior managers (their pants are very fancy and so the reports have to look good)
Things that I have tried:
1. changing the paper type around and playing the the margins, but it only makes the stretching worse when it flips to portrait
2. I even tried changing the design of the form to cut off .333 of an inch, but then it still prints 2x the number of pages, but that next page is just blank.
3. Searching the internets for an answer
ANY suggestions would be GREATLY appreciated!!