P
Peter
I have a number of reports, some with portrait layout and some landscape, but
I have trouble getting the landscape reports to print correctly.
Portrait is the default for the printer in question, and all the reports
want to print that way, so those that are arranged in a landscape fashion
usually print incorrectly over several pages.
The only method I have managed to get to change the orientation is once the
report is in preview mode, manually change the page setup AND then go into
the printer properties and change it there as well otherwise it's portrait
all the way. Only changing one of these settings will not work and it doesn't
matter which one, interestingly enough, the page setup option is usually
always set correctly for landscape, but the preview is portrait anyway.
This is inconvenient since not all users who will use this DB have access to
the printer settings, much less the time to adjust this setting for every
report that they run.
I have tried using 'Me.Printer.Orientation = 2' in the open event of the
reports in question but that had no effect on the print orientation, I also
wrote a function to set the printer orientation prior to printing, same
result. I tried running the function before the reports were run and after
reporting but before printing, all with no result.
Perhaps I am not referencing the printer correctly, can anyone offer any
ideas?
The OS is Windows XP Pro, Access is 2003 and the printer is HP Jaserjet 4000
with PCL 5e driver.
I have trouble getting the landscape reports to print correctly.
Portrait is the default for the printer in question, and all the reports
want to print that way, so those that are arranged in a landscape fashion
usually print incorrectly over several pages.
The only method I have managed to get to change the orientation is once the
report is in preview mode, manually change the page setup AND then go into
the printer properties and change it there as well otherwise it's portrait
all the way. Only changing one of these settings will not work and it doesn't
matter which one, interestingly enough, the page setup option is usually
always set correctly for landscape, but the preview is portrait anyway.
This is inconvenient since not all users who will use this DB have access to
the printer settings, much less the time to adjust this setting for every
report that they run.
I have tried using 'Me.Printer.Orientation = 2' in the open event of the
reports in question but that had no effect on the print orientation, I also
wrote a function to set the printer orientation prior to printing, same
result. I tried running the function before the reports were run and after
reporting but before printing, all with no result.
Perhaps I am not referencing the printer correctly, can anyone offer any
ideas?
The OS is Windows XP Pro, Access is 2003 and the printer is HP Jaserjet 4000
with PCL 5e driver.