printing a line every 5 records

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

Hi

I would like my report to print a line every 5 records to make it easier to
read. Can anyone tell me how to do this? Or refer me to a web page that has
instructions?

Many thanks

Dave
 
Dave,
Add an unbound control to the detail section.
Set it's control source to
=1
Set it's Running Sum property to
Over All (or Over Group if appropriate)
Name this control 'CountRecs'

Add a Line to the bottom of the section.

Code the Detail Format event:
LineName.Visible = [CountRecs] Mod 5 = 0

That should do it.
 
Back
Top