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 Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Printing a single page report Access 2000

Status
Not open for further replies.

MIKElaw

Programmer
Nov 4, 2000
116
GB
One page report

Call 'Print Preview' and hit the 'Print' Button on the toolbar. -- One Page; one copy

hit the Print button on the form
which executes

stDocName = "JobRep"
DoCmd.SelectObject acReport, stDocName, True
DoCmd.PrintOut , , , , 3

Produces 3 copies OK but each one is two pages; one text and one blank ??? Why are the two print methods so different??
Any clues most welcome

 
Clues:
If you open the report and go to Print Preview, how many pages show up there. If it's two, then the report has something spilling over to another page. If it's 1 page, then the only other thing I could think of would be default printer settings.

Paul
 

I think that even if there's "white space" extending
over the right-hand margin it will be printed on the
next page. Try putting a label on the RHS. Also
shorten the report's width or increase the margin.

hth,
Wayne
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top