memo field truncates

C

Curtis

When I run a query that includes a memo field the query
results are truncated. Any way to resolve this?
 
J

John Spencer (MVP)

Possibly. Can you post your SQL statement?

Some things that can truncate memo fields are
Using Distinct
Applying a format to the memo field
Using a Union query
 
S

Sidney Linkers

Hi Curtis,

I'm not sure what you mean by "...results are truncated.". If you mean that
you will get less records in the recordsset than without the memofield,
please show us the SQL statement.

Have you tried to put the cursor in the memofield and then manually walk the
cursus with "arrow right" to the end of the memofield?
Have you tried to change the width and height of the cell where the memo is
displayed. If the memo has <newline> (CTRL-M) characters in it then you dont
see the next row, unless you change the height of the row.
 

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

Similar Threads

Make Table Query Truncating Memo Field at 255 Characters 1
Force data type from Text to Memo in a simple Make Table Query 1
Unusual reason for Memo truncation 2
appending more than 255 characters into a Memo field 7
Memo Field is truncated 5
.MDB memo fields being truncated during Word merge 0
Export to excel has character limit 3
TransferText export is truncating field 2

Top