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.
 
Back
Top