Pages property problem

[Zippy]

I have a report which has a list of products, with a total page count.
Due to layout concerns, the client wants to be able to adjust how many
products are printed on a page.

What I do, is keep a count of products and force a page break when the
total no of products per page is reached. (It is a very messy business.
I have been trying unsuccessfully to convince them to change the layout
to avoid this need).

The problem now is that the total number of pages does not adjust itself
and they get 'Page 14 of 13', etc.

I know that Access does a pre-run to count the total pages. Then I come
and add in page breaks, which increases the number of pages, so I can
understand why this is happening. However, this report has been up and
running for over a year, and until now they haven't had this problem,
though this *may* be because they had only printed shorter lists and the
page adjustments didn't actually change the total number of pages.

Does anyone know have any idea why this is happening, and what I can do?
(Client is frantic as they say they have to urgently print and send off
the report.).

Thank you.
--
Zippy S

[Zippy]

Forgot to add: I'm working in A97, if that makes a difference.
Thanks.
--
Zippy S

[Marshall Barton]

Zippy wrote:

>I have a report which has a list of products, with a total page count.
Due to layout concerns, the client wants to be able to adjust how many
products are printed on a page.

What I do, is keep a count of products and force a page break when the
total no of products per page is reached. (It is a very messy business.
I have been trying unsuccessfully to convince them to change the layout
to avoid this need).

The problem now is that the total number of pages does not adjust itself
and they get 'Page 14 of 13', etc.

I know that Access does a pre-run to count the total pages. Then I come
and add in page breaks, which increases the number of pages, so I can
understand why this is happening. However, this report has been up and
running for over a year, and until now they haven't had this problem,
though this *may* be because they had only printed shorter lists and the
page adjustments didn't actually change the total number of pages.

Does anyone know have any idea why this is happening, and what I can do?
(Client is frantic as they say they have to urgently print and send off
the report.).

If you want to print N details per page and that many
details are guaranteed to fit on a page, then use a
RunningSum text box (expression =1, RunningSum Over All) to
number the details. Then a Page Break control at the bottom
of the detail section can do the job:
Me.pgBreak.Visible = (txtDetailCount Mod N = 0)

If the details can grow so you can not guarantee N will fit
on a page, then you need to use a running total of the
detail count printed prior to the current page
(ala http://support.microsoft.com/kb/132017/en-us)
so you can determine when to make the page break control
visible:
Me.pgBreak.Visible = (txtDetailCount - pgfootertotal >= 3)

--
Marsh

[Tom]

On Feb 8, 3:33 am, Zippy <[e-mail]:

I have a report which has a list of products, with a total page count.
Due to layout concerns, the client wants to be able to adjust how many
products are printed on a page.

What I do, is keep a count of products and force a page break when the
total no of products per page is reached. (It is a very messy business.
I have been trying unsuccessfully to convince them to change the layout
to avoid this need).

The problem now is that the total number of pages does not adjust itself
and they get 'Page 14 of 13', etc.

I know that Access does a pre-run to count the total pages. Then I come
and add in page breaks, which increases the number of pages, so I can
understand why this is happening. However, this report has been up and
running for over a year, and until now they haven't had this problem,
though this *may* be because they had only printed shorter lists and the
page adjustments didn't actually change the total number of pages.

Does anyone know have any idea why this is happening, and what I can do?
(Client is frantic as they say they have to urgently print and send off
the report.).

Thank you.
--
Zippy S

Zippy:
One solution is to avoid the entire problem and just delete the "of
13" part...

Tom