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?
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?