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
|
|||
|
|||
text box in report is truncating memo field at 255 characters
I've got a text box in a report that has a memo field as the control source.
I also have the Can Grow property of that control set to "Yes," but it truncates the data in that field to a maximum of 255 characters. How can I get this text box to display all the characters in the memo field when the report prints? Thanks in advance, Paul |
#2
|
|||
|
|||
text box in report is truncating memo field at 255 characters
This question gets asked quite often. Did you check the record source query
to make sure it displays more than 255 characters? This would be caused by phrases in your record source query like: GROUP BY, UNION, or DISTINCT. If the query returns all characters then your issue might be with a value in the format property or the text box residing in a group section of the report. -- Duane Hookom Microsoft Access MVP "Paul" wrote: I've got a text box in a report that has a memo field as the control source. I also have the Can Grow property of that control set to "Yes," but it truncates the data in that field to a maximum of 255 characters. How can I get this text box to display all the characters in the memo field when the report prints? Thanks in advance, Paul . |
#3
|
|||
|
|||
text box in report is truncating memo field at 255 characters
You're right, Duane, I had SELECT DISTINCT in the query. Once I removed the
DISTINCT, it displayed all the characters in the field. Thanks for your help with this. Paul "Duane Hookom" wrote in message ... This question gets asked quite often. Did you check the record source query to make sure it displays more than 255 characters? This would be caused by phrases in your record source query like: GROUP BY, UNION, or DISTINCT. If the query returns all characters then your issue might be with a value in the format property or the text box residing in a group section of the report. -- Duane Hookom Microsoft Access MVP "Paul" wrote: I've got a text box in a report that has a memo field as the control source. I also have the Can Grow property of that control set to "Yes," but it truncates the data in that field to a maximum of 255 characters. How can I get this text box to display all the characters in the memo field when the report prints? Thanks in advance, Paul . |
Thread Tools | |
Display Modes | |
|
|