Reset Row Count of Report

[gatorcc]

I need help getting my row count to reset back to 1 on after a page break. I used a text box with Control Source =1 and Running Sum = Over All. I have it set for the page break to occur at 25 records. Any ideas?

[OBP]

You could use VBA to do the counting instead of the Running sum and then reset it back to 1 when it reaches 26.
Starting with a field called counter on the report, on the Report's On Load Event enter me.counter = 0
Try adding this to the Detail's On Format Event Procedure
me.counter = me.counter +1
If me.counter = 26 then me.counter = 1