Print to Printer dispays value not on print preview of report
- From: "AaronWestcott via AccessMonster.com" <u30340@uwe>
- Date: Thu, 18 Jan 2007 17:12:08 GMT
Hello all,
I have a report that looks back at the previous 20 years of data and prints
the values and the % change from the previous year. All the data, including
the % change are contained in a table (not my doing). I have written some
code (see below) to not display the percent change of the first year reported.
The reports previews fine but when I print the value for % change for the
first record actually prints.
More Detail: I have a field TOTCHG that has the percent change stored in it.
I created a text box to display the value contained in TOTCHG except for the
first record. The code to do this is below.
Option Compare Database
Option Explicit
Dim counter As Integer
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If counter = 0 Then
Me.Text21 = ""
Else
Me.Text21 = Me.TOTCHG
End If
counter = counter + 1
End Sub
Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)
End Sub
Any ideas that anybody may have would be greatly aprpeciated.
Aaron
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-reports/200701/1
.
- Follow-Ups:
- Re: Print to Printer dispays value not on print preview of report
- From: Marshall Barton
- Re: Print to Printer dispays value not on print preview of report
- Prev by Date: Re: Suppressing address lines
- Next by Date: Re: Is It Possible to Have Details Among Two Report Groupings?
- Previous by thread: Suppressing address lines
- Next by thread: Re: Print to Printer dispays value not on print preview of report
- Index(es):
Relevant Pages
|
