Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Print form in Landscape 1

Status
Not open for further replies.

ThinWhiteDude

Technical User
Sep 21, 2004
97
0
0
US
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
 
HUGE APOLOGY TO THE WHOLE FOUM:

Please don't waste your time on this one, I found out what I was doing wrong, am almost too embarassed to admit it, but I had put another print command earlier in the procedure, that I missed. . . .

Again, humblest apologies to all.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top