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
|
|||
|
|||
How do I force a memo field to print all text in reports?
I created a memo field in a table to hold lengthy explanations however when I
preview this field in a report it's cutting off the majority of the text. Usually one or two lines are printing. I've expanded the field to accomodate more characters but that isn't working either. Do you have any suggestions on how to force the field to display all the text? I appreciate any help you can provide. |
#2
|
|||
|
|||
How do I force a memo field to print all text in reports?
Memos on reports can be problematic at times. Most likely it is
truncating down to 255 characters? Is the report's recordsource a query? Some queries will truncate memo fields automatically, such as Crosstabs, Summary, Union, and SELECT DISTINCT. This site has some more insight: http://allenbrowne.com/ser-63.html |
#3
|
|||
|
|||
How do I force a memo field to print all text in reports?
"PF509" wrote: I created a memo field in a table to hold lengthy explanations however when I preview this field in a report it's cutting off the majority of the text. Usually one or two lines are printing. I've expanded the field to accomodate more characters but that isn't working either. Do you have any suggestions on how to force the field to display all the text? I appreciate any help you can provide. Have you examined the "CanGrow" property of the report (text box) field? If this is set to "No" (the default), then you will get truncation based on the size you choose for the field. |
Thread Tools | |
Display Modes | |
|
|