Incorrect Print Report

T

Timothy Langaster

In print preview I can see the correct report where the total amount appears
in the last page of an invoice but if I try to print the report out, this
total appears in all pages.
In the previous version of Access XP the print was correct. The problem
starts with Access 2007.
Any idea how to solve the problem?
Here below is the property sheet On Open [Event Procedure]
VERSION 1.0 CLASS
BEGIN
MultiUse = -1 'True
END
Attribute VB_Name = "Report_INVOICE"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = True
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Compare Database 'Use database order for string comparisons
Private Sub PageHeader0_Format(Cancel As Integer, FormatCount As Integer)
' At top of page, initialize controls in detail section.
' Set Visible property to show controls in detail record
If Page = Pages Then
Me![Embedded112].Visible = True
Me![Text122].Visible = False
Else
Me![Embedded112].Visible = False
Me![Text122].Visible = True
End If
End Sub
Private Sub Report_Open(Cancel As Integer)
DoCmd.Maximize
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

Word macro that can call cells out of Excel for a find and replace 0
Detail_Format works in Print Preview but Not When Printing 0
What is Attributes and WithEvents??? 4
VBA Export to PDF 0
First Report always "true" 3
3 labels per report page problem 0
Label in Multi column report 0
Print out is different from Print Preview for a Multi-Column report 1

Top