To avoid truncation of a memo field in a query you don't use the DISTINCT predicate nor GROUP BYthis field nor use any aggregate function on it.
What is the SQL code of your query and the name of the memo field ?
the field that is truncating is description. My form and reports derive its data from the query.
I find that if I export to MS Word, all the data, including a record with more than 255 characters, is exported. I just can't see it on the form or report.
Below is the field "description" Most records are less than 255 characters, but for ease of observation, I restricted the query to records > 400 characters.
SELECT tblLseTracts.Description, Len([description]) AS [Char]
FROM tblLseTracts
WHERE (((Len([description]))>400));
Are you suggesting the Description gets truncated in the provided SQL statement?
Setting the Format property of a control on a form or report will also truncate the value. Text values in Group Headers or Footers may also be truncated.
Check the table design of tblLseTracts and look for anything in the Format property of the Description field. If there is something there, remove it. There might even be a space hidden there.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.