Truncated memo field in query

[JC]

I have a pretty large query that is joining 5 tables in my
Access 2000 database. When i run the query one of the memo
fields (the only one in the query) is truncated to 255
characters when the query is displayed.

All the data in the table stays the same it just displays
the truncated memo field in the query.

Any help with this problem would be greatly appreciated.

JC

 

[John Vinson]

I have a pretty large query that is joining 5 tables in my
Access 2000 database. When i run the query one of the memo
fields (the only one in the query) is truncated to 255
characters when the query is displayed.

All the data in the table stays the same it just displays
the truncated memo field in the query.

Any help with this problem would be greatly appreciated.

JC

Are you perchance sorting or grouping by the field? If so, don't -
either operation will truncate the field. If not, post the SQL.

 

[Joan Wild]

Remove any formatting you may have on the field in the underlying table.

 

[ANARCHYMM]

None of the answers below resolved my issue.
I had to use the dlookup function in the display


-
ANARCHYM