Querying memo fields.

C

caloy

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.
 
D

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.
 
C

caloy

Doug,

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

RoadKyng

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.
 
J

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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top