Querying memo fields.

[Guest]

I have a table and a couple of the columns are "memo" data field types. Now,
when I'm querying this table, the memo fields get cut short in the query
after acertain length. I s there a way so that this will not happen; so that
I can see the whole field.

 

[Douglas J. Steele]

Are you using any functions on the Memo fields or are you sorting on them?
Either one will truncate the data at 255 characters.

 

[Guest]

Doug,

Thanks for your response. I'm just doing straight querying what's on the
table.

 

[Guest]

I am in need of answer to this problem myself. I use memo type fields that
hold strictly text with no sorting or manipulation. I need to return all the
text in a report and the query that pulls the data is truncating.

 

[John W. Vinson]

I am in need of answer to this problem myself. I use memo type fields that
hold strictly text with no sorting or manipulation. I need to return all the
text in a report and the query that pulls the data is truncating.

Just be sure that you avoid the things that truncate memo fields:

- Sorting on the memo field
- Grouping By the memo field in a Totals query
- Using a DISTINCT or UNIQUE VALUES property in the query
- setting a Format (even something as simple as >) on the memo field

John W. Vinson [MVP]

 

[Guest]

That fixed it. Had Unique values selected.

Thanks a bunch!