Memo field entry only prints 255 characters in report 1

[houstonbill]

I did find thread 703-1359243 answered by Dhookom on 4/21/07 that had the same problem that I am having, but my query makeup is different and I can't see why this is happening. My field is set up as memo on the table, and my query that builds the report is based only on that table. I see nothing on this query or the format property for the field that would cause the words to cut off. Below is the SQL that makes up my report:

SELECT Table1.ID, Table1.[Date Opened], Table1.Responsible, Table1.Source, Table1.Issue
FROM Table1
WHERE (((Table1.[Date Closed]) Is Null))
GROUP BY Table1.ID, Table1.[Date Opened], Table1.Responsible, Table1.Source, Table1.Issue;

 

[dhookom]

Group By queries will truncate memo fields at 255 characters. Why are you even using Group By in the query since you are not aggregating anything?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[houstonbill]

Well, I am not sure why I had it as group by. There is not one good reason that I can come up with. Anyway, I removed the group by and it works perfectly now. I have this same problem with a few reports on another database and I will check that as well. I never had a clue that anything like this could affect the memo field. Thanks for opening my eyes.