Another common source of truncation is using a Memo field in a GROUP BY in a query.
John Viescas, author Microsoft Office Access 2007 Inside Out Building Microsoft Access Applications Microsoft Office Access 2003 Inside Out SQL Queries for Mere Mortals http://www.viescas.com/ (Paris, France) For the inside scoop on Access 2007, see: http://blogs.msdn.com/access/ -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Dawn Crosier Sent: Friday, August 24, 2007 4:53 PM To: [email protected] Subject: RE: [ms_access] Memo Field truncated in query result If you are sorting in your Query, then it will truncate to the first 255 characters of your memo field. What most people do to create their report is they create the query and then add the memo field in the record source of the report to get the memo field in there as well. So you would have two queries linked together where the one query does the sorting and the other query has the memo field and id field so you can join them together and use them in your report. Dawn Crosier Microsoft Word MVP "Education Lasts a Lifetime" This message is posted to a newsgroup. Please post replies and questions to the newsgroup so that others can learn as well. -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Dave Moreau Sent: Friday, August 24, 2007 7:07 AM To: [email protected] Subject: [ms_access] Memo Field truncated in query result Why would a memo field be trunacted in a memo field when running a query/report? The query does not pull all of the text in from the table....all of the information is in the table but the query on the memo field truncates the entry in the report. The report filed is set to Can Grow but I noted the query itself is truncating the memo field - thus the report is not fed all of the data. Thanks! Dave Moreau = = = = = = = = = = = = = = = = = = = = = No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.484 / Virus Database: 269.12.2/967 - Release Date: 8/22/2007 6:51 PM Yahoo! Groups Links
