Problem returing data from Memo fields when queried in Access 2000

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Steve Hankin - 11 May 2005 13:30 GMT

When I use a date-parameterised query in Access 2000, the data returned from
my Memo-type fields in the queried table is truncated to 255 chars.

Is there a way to fix this so that all of the characters held in the memo
fields can be returned by the query and subsequently displayed in a report?

Reply to this Message

Marshall Barton - 11 May 2005 16:33 GMT

>When I use a date-parameterised query in Access 2000, the data returned from
>my Memo-type fields in the queried table is truncated to 255 chars.
>
>Is there a way to fix this so that all of the characters held in the memo
>fields can be returned by the query and subsequently displayed in a report?

Using a parameter should have no effect on memo field
truncation. The usual cause of truncation is the use of the
memo field in a Group By clause. A UNION query and a few
other things will also cause it.

We need more details to pin it down. For instance, if you
have specified the query field's Format property, or are
displaying the memo field in a form/report text box with its
Format property, then it will be truncated at display time.

If those clues don't get you going in the right direction,
post back with the query's SQL statement and an explanation
of how you are viewing the memo field.

Signature

Marsh
MVP [MS Access]

Reply to this Message

Chaim - 11 May 2005 16:42 GMT

Also, try searching on 'memo field truncation' in 'MSDN Newsgroups'. There
are quite a number of similar questions with answers.

> >When I use a date-parameterised query in Access 2000, the data returned from
> >my Memo-type fields in the queried table is truncated to 255 chars.
[quoted text clipped - 15 lines]
> post back with the query's SQL statement and an explanation
> of how you are viewing the memo field.

Reply to this Message