Conditional Page Break produces intermediate blank pages

Hi:

I am trying conditional page breaks in a report so I followed th advice in
Access help that says you have put a page break control in the section
youwant the break, then in the page header set the visible property to false
in the format event. in the detail section were I put the page break control
I have a record counter and in the format event for the section whenever the
counter reaches 15 and it multiples I set the visible property of the
pagebreak control to true. But the amazing thing is that produces 4 pages of
a report that should have only 2 pages (pages 2 and 4 are empty). Any help
will be greatly appreciated

ijazbof wrote:
I am trying conditional page breaks in a report so I followed th advice in
Access help that says you have put a page break control in the section
youwant the break, then in the page header set the visible property to false
in the format event. in the detail section were I put the page break control
I have a record counter and in the format event for the section whenever the
counter reaches 15 and it multiples I set the visible property of the
pagebreak control to true. But the amazing thing is that produces 4 pages of
a report that should have only 2 pages (pages 2 and 4 are empty). Any help
will be greatly appreciated


Lots of possible issues here.

Do you get the blank pages without the page breaks?

Maybe the detail has already spilled over to a new page?
What happens if you set the page breaks to occur after14
details?

How are you counting the details? If you're doing it with
code in the Format event procedure, you will have some
anomalous results. It should be done using a detail section
text box with the expression =1 and RunningSum set to Over
All or Over Group as appropriate.

--
Marsh
MVP [MS Access]

Thanks for your clues, it was not exactly the same flaw you mention but
forced me to re-think the report logic.

Regards
Hugo Alberto

"Marshall Barton" wrote:

ijazbof wrote:
I am trying conditional page breaks in a report so I followed th advice in
Access help that says you have put a page break control in the section
youwant the break, then in the page header set the visible property to false
in the format event. in the detail section were I put the page break control
I have a record counter and in the format event for the section whenever the
counter reaches 15 and it multiples I set the visible property of the
pagebreak control to true. But the amazing thing is that produces 4 pages of
a report that should have only 2 pages (pages 2 and 4 are empty). Any help
will be greatly appreciated


Lots of possible issues here.

Do you get the blank pages without the page breaks?

Maybe the detail has already spilled over to a new page?
What happens if you set the page breaks to occur after14
details?

How are you counting the details? If you're doing it with
code in the Format event procedure, you will have some
anomalous results. It should be done using a detail section
text box with the expression =1 and RunningSum set to Over
All or Over Group as appropriate.

--
Marsh
MVP [MS Access]