If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Printing Memo Fields
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! |
#2
|
|||
|
|||
Printing Memo Fields
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. On Wed, 19 May 2004 05:50:00 -0700, "Tim Demijohn" wrote: 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 |
Thread Tools | |
Display Modes | |
|
|