I have a truncated memo field in my report 1

[turpen]

I am a begginer ACCESS user, and have a report that is truncating a memo field. I have looked at the Can grow/can shrink fields but can't eliminate the truncation. I would like the entire memo field to be veiwable on the report.

Any help out there?

 

[dhookom]

Is the entire memo field displayed in the datasheet view of the report's record source?

If the query is doing the truncating then you probably have phrases in your SQL like "DISTINCT" or "GROUP BY".

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]

 

[turpen]

Thank you. The query is truncating the memo feld. How do I address that? I am aksing the query to perform a count for me so the total button has been enabled.

 

[dhookom]

You can't return more than 255 characters from a field that is in the Group By clause. You might be able to change the field from Group By to First.

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]