Problem returing data from Memo fields when queried in Access 2000

[Guest]

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?

 

[Marshall Barton]

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.

 

[Guest]

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