pagebreak with out breaking a record.

R

rafaeljsg

Hello I have a report that has a number or record, this record hold a number
of line of data, example:

job 1 my house
builder xxxxx
arch xxxxx
ect. xxxxx
ect. xxxx

ok what I get is about 4 1/2 record is some pages if the report it varies, I
need the report not to break the record, so if a record is going to break
start new page
please help and thank you in advance.

Rafaeljsg
 
J

John Spencer

Have you set the Keep Together property of the section to Yes?

John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
 
M

Marshall Barton

rafaeljsg said:
Hello I have a report that has a number or record, this record hold a number
of line of data, example:

job 1 my house
builder xxxxx
arch xxxxx
ect. xxxxx
ect. xxxx

ok what I get is about 4 1/2 record is some pages if the report it varies, I
need the report not to break the record, so if a record is going to break
start new page


Try setting the detail section's KeepTogether property to
Yes.
 
R

rafaeljsg

yes I have the KeepTogether property on yes, but no change
maybe this helps

the header
is the job# header
then is detail
with the other data:

builder xxxxx
arch xxxxx
ect. xxxxx
ect. xxxx

by the way thanks for all your help in advance.

rafaeljsg
 
M

Marshall Barton

rafaeljsg said:
yes I have the KeepTogether property on yes, but no change
maybe this helps

the header
is the job# header
then is detail
with the other data:

builder xxxxx
arch xxxxx
ect. xxxxx
ect. xxxx


The Detail section's KeepTogether property is supposed to
prevent a single detail section's data from being split
across a page boundary. Of course it can't be done for a
detail record that won't fit on a page by itself.

If that is not happening for you, then either something is
broken or you have a different situation than described in
your post.
 
J

John Spencer

If you are trying to keep the header with multiple detail lines then you need
to use the sorting and grouping dialog and set Keep Together property for the
group to "Whole Group".


John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top