Page 21 of 20 (?!?)

  • Thread starter Thread starter Jeff Boyce
  • Start date Start date
J

Jeff Boyce

Access 2007 front-end, SQL-Server 2000 back-end.

One report out of many (>20), one time over the last 10 years (with earlier
versions of Access).

User reports "Page 21 of 20" ... and there are 21 physical pages.

On-line search and HELP search have not (yet) revealed an issue/solution.

Anyone out there seen this behavior before? Seen a solution before?

Regards

Jeff Boyce
 
Jeff said:
Access 2007 front-end, SQL-Server 2000 back-end.

One report out of many (>20), one time over the last 10 years (with earlier
versions of Access).

User reports "Page 21 of 20" ... and there are 21 physical pages.

On-line search and HELP search have not (yet) revealed an issue/solution.

Anyone out there seen this behavior before? Seen a solution before?
Click to expand...


See that a fair amount. The problem is almost always some
code that makes something visible on only the last page.
The code might be along these lines:

Me.something.Visible = (Me.Page = Me.Pages)

The first time Access goes through the report to calculate
the number of pages, the value of Pages is zero so the
something is invisible and the calculated number of pages is
20. But the second time through, the something is made
visible and, if it spills over to another page, then there
will be more than 20 pages.

You can also Page 19 of 20 on the last page if something is
made invisible on the last page.
 
Thanks, Marsh. I hadn't run into that before.

Now I'll check to see if the report is running any .Visible code...

Regards

Jeff Boyce
 
Back
Top