Line after 4th record in report detail?

[datarepro]

I am developing in Access 97, and I would like to print a single line after every 4th record in my report detail to separate records. I have searched this forum, and FAQ and cannot seem to find anything... Any suggestions?

Thank you.

 

[Guest_imported]

To do this, put an unbound textbox on your Report. I'll call it TextSum. Set the Control Source to =1, set the running sum property to Over All, and set the visible property to No. Then add the line, I'll call Line10 just below your textboxes and set the Visible property to No. In the Format event for your Detail Section put this code. Make the necessary adjustments to the control names.
If TextSum Mod 4 = 0 Then
Me.Line10.Visible = Yes
Else
Me.Line10.Visible = No
End If

 

[datarepro]

Thanks for your help, I will give it a try!

 

[datarepro]

Worked like a charm!