ThinWhiteDude
Technical User
Using Access 2003, here's the story:
My client wants a form to print, once users are done filling it out --He does NOT want a report made, but the actual form.
I have been trying to get the thing to print out in landscape using the following code on the click event of a command button:
Me.Printer.Orientation = acPRORLandscape
DoCmd.PrintOut acSelection, 1, 1, acHigh, 1
The thing is it's printing twice: once in portrait (the default setting) and the second copy is in landscape.
I commented out the 2nd line and found the first line is actually printing before the setting "takes"
Have I got something obviously wrong in that line?
As always, any help will be greatly appreciated.
TWD
My client wants a form to print, once users are done filling it out --He does NOT want a report made, but the actual form.
I have been trying to get the thing to print out in landscape using the following code on the click event of a command button:
Me.Printer.Orientation = acPRORLandscape
DoCmd.PrintOut acSelection, 1, 1, acHigh, 1
The thing is it's printing twice: once in portrait (the default setting) and the second copy is in landscape.
I commented out the 2nd line and found the first line is actually printing before the setting "takes"
Have I got something obviously wrong in that line?
As always, any help will be greatly appreciated.
TWD