Page 21 of 20 (?!?)

[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

 

[Marshall Barton]

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?

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.

 

[Jeff Boyce]

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