By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,825 Members | 1,697 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,825 IT Pros & Developers. It's quick & easy.

Split a Memo field

P: n/a
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
Share this Question
Share on Google+
4 Replies


P: n/a
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

P: n/a
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

P: n/a
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

P: n/a
"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

This discussion thread is closed

Replies have been disabled for this discussion.