memo field truncates

  • Thread starter Thread starter Curtis
  • Start date Start date
C

Curtis

When I run a query that includes a memo field the query
results are truncated. Any way to resolve this?
 
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
 
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.
 
You must log in or register to reply here.

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 2
Memo Field is truncated 5
Force data type from Text to Memo in a simple Make Table Query 1
Unusual reason for Memo truncation 2
Union query changes Memo to Text (256 char limit) 1
Memo Field Truncating in Query 7
How eliminate duplicate memo columns? 2
Does a Select query copy memo fields correctly? 1

Back
Top