Querying a Memo field Only returns part of info

[commandolomo]

Hello All

Has anyone ever encoutered a problem where when running a query to return a dataset which includes a memo field, the query only returns part of the info contained in the memo field?

Do queries limit the return of memo field data to 255 characters? I have run other queries on other memo fields in the past, and do not recall ever having this problem.

FYI, there is no indexing, criteria or joins/relationships on the memo field - whilst returning other fields, I purley wanna return whatever is contained in the field.

Any ideas?


Cheers

 

[DJN]

If you are trying to sort or group on a memo field, then Access will only display the first 255 characters.

 

[commandolomo]

Mmmmm, many thanks for the info, can't remember if I grouped on this or not. Am off-site at the mo, but will check when I get back.

Cheers for the help DJN

 

[Rich]

Do you have any formatting applied to the memo text?

 

[paul10]

I have got the same problem - my query groups on a memo field and only displays the first 255 characters - is there any way around this????

 

[Rich]

You can't group on a memo field