dmv1947 said:
I am using Access 2003 (Access 2000 file format).
Sometimes when generating a report I get an unsual page count "Page 35 of
32". The database is split front end / backend. The backend is on a shared
drive with the front ends on local PCs.
Whoa, that's really strange. I have seen things like
Page 33 of 32 or even Page 31 of 32, but never off by more
than one. I don't think I can reproduce your situation so
I'll try to explain how the pages can get out of sync like
that.
First, it's important to understand how the value of Pages
is calculated. To do this Access must format the entire
report so it can figure out how many pages there are. Then
Access has to go back to the beginning and format the report
a second time with the value of Pages now available.
If you have any code in a format event procedure that makes
things visible/invisible so that CanGrow/CanShrink might be
different the second time through, then what you're seeing
is possible. Another, less likely, scenario is if the value
of Pages is used in such a way to make a text box grow and
along with the section's (or group's) KeepTogether property
could cause the second tie aroun come out quite differently
that it did the first time.
It can get tricky to figure out what it is, but you can be
99.99% sure it's something you are doing to cause this
behavior.
