Printing Memo Fields

[Tim Demijohn]

I have a report in which I'd like to "break" a memo field
so part of the field prints on one page and the rest of
the field prints on the next page. For example: I have
15 LF on a page. My memo field has 20 lines. I want 15
lines of the memo field on the first page and the
remaining memo field lines on the second page.

Is this possible?

Thanks for your help!

 

[Peter R. Fletcher]

I don't think that you can do _exactly_ what you want to do in Access.
I can't think of a way to split a memo field between two Report
controls and be sure that the break occurs where it would if you could
break the text "natually" between pages. What is certainly possible is
to work out how many _characters_ you would expect (on average) to fit
on the first page, erring on the low side, break the memo field at the
last whitespace character before that number of characters is reached,
and print the first part of the original field from one control and
the second part from the next one.

Another approach, particularly if your report is a relatively simply,
linear, one, would be to consider using Automation to write it in
Word, which will automatically handle pagination nicely for you.

I have a report in which I'd like to "break" a memo field
so part of the field prints on one page and the rest of
the field prints on the next page. For example: I have
15 LF on a page. My memo field has 20 lines. I want 15
lines of the memo field on the first page and the
remaining memo field lines on the second page.

Is this possible?

Thanks for your help!

Please respond to the Newsgroup, so that others may benefit from the exchange.
Peter R. Fletcher