how to split records in Access report

[associates76]

Hi,

I was wondering if anyone here might be able to help me here. This
problem has been driving me up the wall.

I have a report that shows records in it. Some of the records are
split namely starting on one page finishing on the next.

For example
- Maintenance plan
- Irrigation monitoring plan

where "- Maintenance plan" is all one field and yet the
"- Irrigation monitoring plan" would be printed at the top of the next
page if this
happened to print at the bottom of a page. What should happen if the
two
lines don't fit is that both lines get moved to the next page.

Is it possible to make the report to throw the record onto a new page
if it would not fit on the page area that is left on the previous
page.

I have tried to set Keep together to both "yes and no" under
properties of section 'Detail'. Neither of these did the trick. I've
run out of ideas.

Thank you in advance

 

[John Spencer]

That is strange. If you have set the Keep Together property for the Section
to Yes then Access should print the entire section on the same page (as long
as the entire section will fit on one page).

I've not seen this fail. So let me ask the obvious questions.
-- Are Maintenance plan and Irrigation monitoriing plan in the same section?
-- Are you sure you set the section's keep together property to Yes?
-- Are you sure you set the proper section's keep together property?
-- Will both controls (fields) fit on one page?

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

 

[associates76]

Hi John,

Thank you for your reply.

Sorry for the confusion

The following is what's been set in the report

In the table named "Research Summary", there are fields as follows
RS_ID, Subject, Plan (type of MEMO), Purpose(type of MEMO),
Implementation(type of MEMO)

In the section: Detail in the report
There are four text-boxes which are fields from the table. They are
Subject, Plan, Purpose, and Implementation in the order as below
Subject (Can Grow: yes)
Plan (Can Grow: yes)
Purpose (Can Grow: yes)
Implementation (Can Grow: yes)

If records in the Plan is longer, it will generally push down whatever
has been placed underneath it. Hence, this would cause problems for
the records for Implementation as shown below.

For example
Implementation
- Maintenance plan ------> at the end of the page
- Irrigation monitoring plan

"- Irrigation monitoring plan" would be printed at the top of the next
page.

What I wish for it to happen is if the two lines(or more) don't fit in
one page, the Access would cleverly move both "Maintenance plan" and
"Irrigation monitoring plan" to the next page instead (rather than
having shown some in one page and some in the next page especially
when they are part of the Implementation.

Hope i don't confuse you with my explanation here.

So to answer your question

-- Are Maintenance plan and Irrigation monitoriing plan in the same section?

Yes, they are records appear in the section "Detail"

-- Are you sure you set the section's keep together property to Yes?

Yes, the keep together property set to YES under Section: Detail

-- Are you sure you set the proper section's keep together property?

not sure what you mean - is it Detail section you're referring to?

Thank you in advance

 

[John Spencer]

Ok I think I understand now. You have a CONTROL that is splitting over two
pages.

I think what you may have to do is to add a GROUP to your report based on
the primary key (RS_ID)
-- put the implementation control in the group footer of this new group
-- set the group footer's keep together property to true.
-- set can grow for both the footer and the control

WARNING: This may cause problems if any of the implementation plans are in
excess of one page. The report may go into a perpetual loop as it tries to
find a page where more than one page of data will fit. At least it has
exhibited that type of behavior for me.
--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..