I am using a text box control on a report to display data that is stored in a memo field in one of my tables.... but for some reason it cuts off after a certain amount of characters. EX. My table has a memo field with lets say 15000 characters in the memo field. When I try to display this in a text box control on a report, It doesn't display all the characters. The characters are cut off around 200 or so. (I didnt count) Isn't there some way to get all the characters to display. Is there a text area control in access when creating reports?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
text box isnt displaying all text from memo field
- Thread starter bryant89
- Start date
Ensure that the CanGrow property of the text control on the report is set to Yes. This will allow the size of the control to grow vertically to accomodate the full value of the memo field. This is probably the cause of the problem.
Cheers,
Steve Lewy
Solutions Developer
steve@lewycomputing.com.au
Cheers,
Steve Lewy
Solutions Developer
steve@lewycomputing.com.au
CosmoKramer
Programmer
Also, check to see if you have applied any formatting to the field, such as a >. If so, remove the formatting.
- Thread starter
- #4
Nope, neither of these are the problem I have checked both. For some reason the textbox control on this report wants to truncate the data that is stored in the memo field in the table. When I open up the table, all the data is there but when I try to display it in a textbox control on a report it is truncated. I am not sure to how many characters I just know that it isn't all there. When u say formatting to the field you mean to the memo field in the table right? If so I don't think that is the problem because I can see all the data in the table.
CosmoKramer
Programmer
By field formatting I meant in the report.
Also, make sure the CanGrow property is set to Yes for the report section that the memo field is in. If it's set to No in the section, it negates the setting for the field....
Also, make sure the CanGrow property is set to Yes for the report section that the memo field is in. If it's set to No in the section, it negates the setting for the field....
- Thread starter
- #6
First,
Open your report in Design Mode/ right click on your text field/ check the properties one more time to ensure that the CanGrow setting is "Yes"/
Test: Test to see if the formatting on the text field is the problem by just enlarging the field "drag the text box by a corner to enlarge it. If this doesn't work and you are pulling a large amount of other information into your report. Access might just be having a memory problem. "too much to output at one time"
Create a sub report with only the one "text" field to pull in the data from your memo field. This has always worked for me.
Open your report in Design Mode/ right click on your text field/ check the properties one more time to ensure that the CanGrow setting is "Yes"/
Test: Test to see if the formatting on the text field is the problem by just enlarging the field "drag the text box by a corner to enlarge it. If this doesn't work and you are pulling a large amount of other information into your report. Access might just be having a memory problem. "too much to output at one time"
Create a sub report with only the one "text" field to pull in the data from your memo field. This has always worked for me.
- Thread starter
- #8
I just experienced this same problem. Text control and group footer section were both set to "can grow", but memo field was being truncated at 255 chars. I had to move the control into the detail section to get the complete memo field.
Hey All
I suffered this same problem recently and spent ages trying to work it out. It turned out to be fairly simple in the end and actually related back to the query. For me, this problem was fixed by turning off the 'Show Totals' button (the Sigma character) in query design view. For some reason the reports don't like 'group by' with memo fields.
Obviously this wont help much if you have to have 'Show Totals" on, but hopefully that's helped some of you.
Cheers
Alex
I suffered this same problem recently and spent ages trying to work it out. It turned out to be fairly simple in the end and actually related back to the query. For me, this problem was fixed by turning off the 'Show Totals' button (the Sigma character) in query design view. For some reason the reports don't like 'group by' with memo fields.
Obviously this wont help much if you have to have 'Show Totals" on, but hopefully that's helped some of you.
Cheers
Alex
- Status
Similar threads
- Locked
- Question
