 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Reports / Printing / March 2007Memo Field is truncating to 255 Chars
The source query is using "totals" and the condition for the memo field is set to "First". This displays the entire contents of the memo field (more than 255 chars), vs using "Group By" which truncates the field to 255 chars. However, even though the entire string displays in the query - only the first 255 print on a report. Is this normal? Is there a way to print the entire string, other than a sub-report? It seems you understand that to get Access to display the entire memo field, you must avoid any aggregation on the field. It sounds like you succeeded in doing that in your query, so (assuming this query is the source for the report), it's time to look at the report. Open it in design view. Open the Sorting And Grouping dialog (View menu.) Anything in there that would cause Access to sort or group on the memo field? Is the memo in the Detail section, or in some group header/footer? Is there anything in the report's OrderBy property? Another place to look is the Format property of the text box that shows the memo. Clear anything from that property.  SignatureAllen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. > The source query is using "totals" and the condition for the memo field is > set to "First". This displays the entire contents of the memo field (more [quoted text clipped - 5 lines] > > Is there a way to print the entire string, other than a sub-report? The answer to your questions is generally "no". I even created a test report using simple dummy data and a simple report which retrieves one record with no grouping. The report truncates the data wheras the query does not, so I am assuming this is normal. My work around is a sub-report, although the above would have been easier if it worked. > It seems you understand that to get Access to display the entire memo > field, you must avoid any aggregation on the field. [quoted text clipped - 18 lines] >> >> Is there a way to print the entire string, other than a sub-report? Okay, so you have a subreport that works, but a main report that doesn't. That may help you to identify what's the difference between the two. SignatureAllen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. > The answer to your questions is generally "no". I even created a test > report using simple dummy data and a simple report which retrieves one [quoted text clipped - 28 lines] >>> >>> Is there a way to print the entire string, other than a sub-report? Yes, the sub-report is based on single table with no grouping - so the memo field does not become an issue > Okay, so you have a subreport that works, but a main report that doesn't. > That may help you to identify what's the difference between the two. [quoted text clipped - 31 lines] >>>> >>>> Is there a way to print the entire string, other than a sub-report? > Yes, the sub-report is based on single table with no grouping - so > the memo field does not become an issue Are you using the memo field in the report to do the grouping? (you can't do that) SignatureRick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com >The answer to your questions is generally "no". I even created a test report >using simple dummy data and a simple report which retrieves one record with [quoted text clipped - 5 lines] >My work around is a sub-report, although the above would have been easier if >it worked. To add to Allen's list of things to check. Did you make sure the memo's text box and its section bothe have their CanGrow property set to Yes? IMO, once the query is doing the right thing, this problem is usually caused by some kind of grouping, aggregation or sortingon the memo field. SignatureMarsh MVP [MS Access] |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.