Line number

[M8KWR]

I have created a report, but would like the line number next to each records, so if the report shows 9 records then obvioulsy 1 to 9, or whatever this may be.....

So what i have done is but this code within the detail_format

Public Count123 ' i put this above the private sub for detail_format.


Count123 = Count123 + 1

Me.Label98.Caption = Count123


This all work great apart from when the report spans more then 1 pages, and the next record on the new page increase by an addiitional 1. SO for example on page 1 there could be 8 records, number 1-8, and then overflows to page 2 where there are 4 records, but it starts at 10 and goes to number 13

i am using A97 is this makes things a bit different... any help would be gratefully recieved and thanks in advance.

 

[KenHigg]

Add a text box to contain the number. Set the control source to '=1' and then set the 'Running Sum' property to 'Over All'.

 

[M8KWR]

fantastic, many thanks

 

[KenHigg]

You're welcome -