• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 875
  • Last Modified:

MS Access report row count

Hi Experts,

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.

Please help
  • 2
1 Solution
Hello colin_palmer,

Use the Print event.  The format event fires twice in many situations.

colin_palmerAuthor Commented:
That works a treat. thanks
Great news.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now