Insert a line on a Acess 2000 report with a label 1

[pdono]

Is there any way to insert a label after certain records have been printed?

I had a strange user request asking if when a report reaches record 50 and 100 on an Access 2000 report, to insert a line which just has a label on it.(Each break would have a deifferent label text)

I experimented with the print event using the move layout, next reord and print selection methods. It appears I can surpress a record, but I can not insert a line with a label.

I advised the user to export the report in Excel and insert the line.

 

[hermanlaksko]

On the report you could add a counter ie. a textbox made invisiable ans setup like this:
Call tha control CountIt
Controlsource=1
Running sum=over all
Also Create a line on the report.

In the on format event on the reports detail section insert the following code:
If Me!CountIt Mod 50 Then Me!YrLine.Visible = False Else Me!YrLine.Visible = True
This does the trick.
Herman