Print Certain Number of Pages

L

Lamar

Depending on a value criteria from a form, I do not want the first page of a
report to print. I want to put the coding in the report. The report does
not have a set number of pages. So sometimes the report will 2 pages or 10
pages. So it varies. Sometimes I will just need to have the first page
print.

I have tried. Any help is appreciated. Thanks

Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)

Dim strSendBack As String

strSendBack = [Forms]![FaxEmployment2]![cmbSendBack]

If strSendBack = "MAIL" Then
DoCmd.PrintOut acPages, 2
Else
End If

End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Page numbering with Merged Document and IF statements 1
Detail_Format works in Print Preview but Not When Printing 0
3 labels per report page problem 0
3 labels per page - Allen Browne or FredG maybe??? 0
Print and Collate 2 seperate reports 0
Page Totals Code error 2
Access2007 won't run report event procedures (e.g. Detail Format) 2
Detail section's Height property does not alter when shrinks / gro 3

Top