MS Access report row count
Posted on 2004-11-02
Subject: MS Access 2000 Reports
In the Detail_Format event I have the following code:
i = i + 1
txtValue.Value = i
This then identifies the row number on the report, which works.
However, I noticed that on some pages (not all) the number in the txtValue text box jumps by two numbers.
For example on page 1 it counts 1 to 23, then on page 2 it counts from 25 to 49 (Following on from some pages is fine). Whats happened to 24?
I do have grouping, however the first two pages are within the same group.
Another problem - if I view the report and then print it, page 1 starts from the number the count ended from when it was previewed. So if there are 100 rows and I print it after previewing it, the count will start from 101. Is there anyway to reset this. I tried putting i=0 in the report activate event but nothing happened.