Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Detail_Print Question 1

Status
Not open for further replies.

striker73

MIS
Jun 7, 2001
376
US
I want to display a box at the end of my report with the sum of the 6 values that I am keeping track of. My report displays everything perfectly on the screen, but not when I print the report.

Some of my formatting code is inside the Detail_Print function, so when I preview the report, the function runs once, and then when I hit "Print", the function runs again and my sum of the total values is double what it should be, although it displays fine on the screen.

Is there any way to tell (within the function) if the function has already been run? I can't just have a counter and see if the counter is more than one because the Detail_Print function is looping through every value it displays. Does this make sense?
 
Read my FAQ in the FAQ area.

Basically reset your accumulation variables on the Page event so that it recalculates correctly when you print.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top