I have heard that in some cases you need to clear fields in the OnFormat of a report because it runs twice. Once when you preview and again on print.
I've attached the code I use in my report because it only works if I go to the last page of the report and then print. If I just preview and print it still doubles the field in the report footer. Is there something more I can do with my code?
Private Sub GroupHeaderCounty_Print(Cancel As Integer, PrintCount As Integer)
curTotal = Nz(curTotal + Me.txtTarget)
Private Sub ReportFooter_Format(Cancel As Integer, FormatCount As Integer)
Me.txtTotTarget = curTotal
Private Sub ReportFooter_Print(Cancel As Integer, PrintCount As Integer)
curTotal = 0