Page Breaks in Access

[Guest]

Folks

Using reports in access I have been able to generate report print outs with the appropriate data, Locations, et
for my client, however there is one major problem

I would like to be able to conditionally include page breaks depending on how many detail records have been show
per page, s.t. pages which otherwise would be half full are to be padded with some portion of the next section's detai
and conversely sections which overrun a page by only a few (lets say up to 8) records to have the page break brough
up so there is a decent (lets say 15 - 20) number of records on the new page

How would I do this? Any suggestions would be appreciate

Shane.

 

[Michel Walsh]

Hi,

The ForceNewPage property of a section can be, at run time, set to 0
(none) or 1 (before the section), or 2 (after the section) or to 3 (both,
before and after), and so, force the page break accordingly.

That is not related to query (as in SELECT ... or as in UPDATE ... ).
The report newsgroup (microsoft.public.access.reports) should have been
more appropriate.


Hoping it may help,
Vanderghast, Access MVP

Folks,

Using reports in access I have been able to generate report print outs

with the appropriate data, Locations, etc

for my client, however there is one major problem.

I would like to be able to conditionally include page breaks depending on

how many detail records have been shown

per page, s.t. pages which otherwise would be half full are to be padded

with some portion of the next section's detail

and conversely sections which overrun a page by only a few (lets say up to

8) records to have the page break brought