i want to print numbers for each row item. I can't use =1 over group or over all because I have artificially produced blank rows which are just the last row a bunch of times.
So I am using this code which I found online
gbl_line_counter = gbl_line_counter + 1
Me.line_number = gbl_line_counter
The problem with this is that the number just keeps increasing without any limit. If I print preview it comes perfectly but then the print starts from the next number - 15. So each time I print the number increases. I moved the code from detail_print to detail_format, but it doesn't seem to reset correctly.
Any ideas on how to tackle this.