Keeping things together

[Guest]

Hello,

My situation: I have 2 memo fields that may hold only a few lines of text,
or up to a page's worth combined. They are set to auto-grow. Below the
fields, there's some text and a subreport, which belong together but are
separate controls. In order to save paper, there's no page break between memo
fields and text/subreport controls. So when the memo fields hold a lot of
text, the text controls and the subreport control underneath may become
separated and end up on different pages.
Is there a way to keep them together so that when they don't fit underneath
the memo fields anymore, they will both be pushed to the next page, and not
just the subreport?

Thank you.

 

[Guest]

I tried moving the text to the subreport's header section, but noticed that
the detail section got broken up, with part of it on one page, and the rest
on the other.

 

[Marshall Barton]

My situation: I have 2 memo fields that may hold only a few lines of text,
or up to a page's worth combined. They are set to auto-grow. Below the
fields, there's some text and a subreport, which belong together but are
separate controls. In order to save paper, there's no page break between memo
fields and text/subreport controls. So when the memo fields hold a lot of
text, the text controls and the subreport control underneath may become
separated and end up on different pages.
Is there a way to keep them together so that when they don't fit underneath
the memo fields anymore, they will both be pushed to the next page, and not
just the subreport?

Since you can only apply the KeepTogether property to a
section, you need to place the text boxes and the subreport
in their own section. This is done by creating a group
(View menu - Sorting and Grouping) with header and/or footer
based on the detail record's primary key field (or a unique
sorting field). Then you can spread your controls over the
group header, detail and group footer sections and set the
section's KeepTogether property as needed.

 

[Guest]

Can you clarify that please?
Do you mean I need to make a new section in the main report? Or the
subreport?

 

[Marshall Barton]

The main report.

You are familiar with Sorting and Grouping (View menu),
right?

 

[Guest]

Ok, thank you.

The main report.

You are familiar with Sorting and Grouping (View menu),
right?
--
Marsh
MVP [MS Access]

Can you clarify that please?
Do you mean I need to make a new section in the main report? Or the
subreport?