Printing (printer) messes up my custom counter

[geraldcor]

After I open the report I am doing from the form, and then attempt to print, the custom counter I am using gets divided by two. I understand it does this because when Access prints it does the whole report again so it is giving me twice the number of entries thereby a smaller average. Is there anyway to get around this. This is kind of an obscure question but any help would be great.

 

[Rich]

Your code is in the wrong event

 

[geraldcor]

What would be the correct event to put my code?

 

[WayneRyan]

geraldcor,

Don't use the Format events, because they can be called
multiple times. Use the DetailPrint event.

Wayne