Split a Memo field

kaplan.gillian

Hi everyone,

I currently have an Access database that includes quite a few
long memo fields. When I create a report of my data, Access
does not allow the memo fields to be split with the page breaks.
In other words, if my memo field is 3 paragraphs long and there
is only space on a report page for 2 paragraphs, rather than
putting 2 paragraphs on one page and the last one on the next
page, all 3 paragraphs are moved to the next page (which creates
a lot of wasted white space on the first page!). I assume
Access does this because it sees the entire memo field as a
'cell' that cannot be split up.

Does anyone have any idea how I can enable Access to split my
memo fields to conform with page lengths? Would using the Split
function work in this case?

Thank you in advance for your help!

Jul 16 '07 #1

chris.nebinger

I don't think that the Split function would help, as that just breaks
a string into an array based on how a delimter, like a space.

My recommendation to you is to use Word as your report writer in this
case, as it will handle paragraphs better than an Access report.
Chris
On Jul 16, 1:45 pm, kaplan.gill...@gmail.com wrote:

Hi everyone,

I currently have an Access database that includes quite a few
long memo fields. When I create a report of my data, Access
does not allow the memo fields to be split with the page breaks.
In other words, if my memo field is 3 paragraphs long and there
is only space on a report page for 2 paragraphs, rather than
putting 2 paragraphs on one page and the last one on the next
page, all 3 paragraphs are moved to the next page (which creates
a lot of wasted white space on the first page!). I assume
Access does this because it sees the entire memo field as a
'cell' that cannot be split up.

Does anyone have any idea how I can enable Access to split my
memo fields to conform with page lengths? Would using the Split
function work in this case?

Thank you in advance for your help!

Jul 16 '07 #2

Allen Browne

You could try setting the Keep Together property of the section that
contains the memo field.

Setting it to No might allow Access to print whatever fits on the page. No
guarantee that it will break at a paragraph break (if that matters.)

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
<ka************@gmail.comwrote in message
news:11**********************@d55g2000hsg.googlegr oups.com...

Hi everyone,

I currently have an Access database that includes quite a few
long memo fields. When I create a report of my data, Access
does not allow the memo fields to be split with the page breaks.
In other words, if my memo field is 3 paragraphs long and there
is only space on a report page for 2 paragraphs, rather than
putting 2 paragraphs on one page and the last one on the next
page, all 3 paragraphs are moved to the next page (which creates
a lot of wasted white space on the first page!). I assume
Access does this because it sees the entire memo field as a
'cell' that cannot be split up.

Does anyone have any idea how I can enable Access to split my
memo fields to conform with page lengths? Would using the Split
function work in this case?

Thank you in advance for your help!

Jul 17 '07 #3

Bob Quintal

ka************@gmail.com wrote in news:1184615108.138313.129120
@d55g2000hsg.googlegroups.com:

Hi everyone,

I currently have an Access database that includes quite a few
long memo fields. When I create a report of my data, Access
does not allow the memo fields to be split with the page

breaks.

In other words, if my memo field is 3 paragraphs long and

there

is only space on a report page for 2 paragraphs, rather than
putting 2 paragraphs on one page and the last one on the next
page, all 3 paragraphs are moved to the next page (which

creates

a lot of wasted white space on the first page!). I assume
Access does this because it sees the entire memo field as a
'cell' that cannot be split up.

Does anyone have any idea how I can enable Access to split my
memo fields to conform with page lengths? Would using the

Split

function work in this case?

Thank you in advance for your help!

Set the 'Keep Together' property of the section (presumably the
detail section,to No.

--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

Jul 17 '07 #4

Bob Quintal

"ch************@gmail.com" <ch************@gmail.comwrote in
news:11**********************@j4g2000prf.googlegro ups.com:

I don't think that the Split function would help, as that just
breaks a string into an array based on how a delimter, like a
space.

My recommendation to you is to use Word as your report writer
in this case, as it will handle paragraphs better than an
Access report.
Chris
On Jul 16, 1:45 pm, kaplan.gill...@gmail.com wrote:

>Hi everyone,

I currently have an Access database that includes quite a few
long memo fields. When I create a report of my data, Access
does not allow the memo fields to be split with the page
breaks. In other words, if my memo field is 3 paragraphs long
and there is only space on a report page for 2 paragraphs,
rather than putting 2 paragraphs on one page and the last one
on the next page, all 3 paragraphs are moved to the next page
(which creates a lot of wasted white space on the first
page!). I assume Access does this because it sees the entire
memo field as a 'cell' that cannot be split up.

Does anyone have any idea how I can enable Access to split my
memo fields to conform with page lengths? Would using the
Split function work in this case?

Thank you in advance for your help!

Set the 'Keep Together' property for the report band (I presume
Detail) to No.
--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

Jul 17 '07 #5