controlling paper source??

  • Thread starter Thread starter mackie
  • Start date Start date
M

mackie

is there a way to control my report printing?

i will be printing a report (full duplexed)
page 1 & 2 will be on heavier stock (i.e. tray 1)

and the rest of the pages, on ordinary bond...(tray 2)

recordsource are grouped by id..

some records may print 3 or more pages

how can i control this?

TIA
 
You might try changing the paper bin in the Page event of the report.

For example, place the following code in the report page event as indicated:



Private Sub Report_Page()

If Report.Page < 2 Then
Me.Printer.PaperBin = acPRBNUpper
Else
Me.Printer.PaperBin = acPRBNLower
End If

End Sub

If you are not familiar with VBA, to place this code:

1. Open report in design view
2. Rt Click on the Detail bar at top.
3. Click on "Build Event".
4. Select "Report" from the top left list box
5. Select "Page" from the top right list box.
6. Paste the code below into the subroutine (minus the 1st & last lines).
7. Select Debug -> Compile ... from top menu.
8. Close and save report.


--
---------------------------------------------------------------
Michael J. Strickland
Quality Services (e-mail address removed)
703-560-7380
---------------------------------------------------------------
is there a way to control my report printing?

i will be printing a report (full duplexed)
page 1 & 2 will be on heavier stock (i.e. tray 1)

and the rest of the pages, on ordinary bond...(tray 2)

recordsource are grouped by id..

some records may print 3 or more pages

how can i control this?

TIA
 
Back
Top