memo restriction??

  • Thread starter Thread starter Andrej Gobec
  • Start date Start date
A

Andrej Gobec

Hello!

I have a query based on a table with a couple of fields having Memo
datatype.

The problem is that this query seems to show only first 255 or so characters
of these Memo fields
whenever I run it. Which is bad! And I don't have a clue why this happens or
how to get past this?

Why would a Memo have the restriction of a Text datatype in a query??

Am I doing something wrong? What should I look at ... Has anyone seen this
before? I'm just lost
and don't have a clue, what's happening?!

thank you in advance,
Andrej
 
Andrej Gobec said:
Hello!

I have a query based on a table with a couple of fields having Memo
datatype.

The problem is that this query seems to show only first 255 or so characters
of these Memo fields
whenever I run it. Which is bad! And I don't have a clue why this happens or
how to get past this?

Why would a Memo have the restriction of a Text datatype in a query??

Am I doing something wrong? What should I look at ... Has anyone seen this
before? I'm just lost
and don't have a clue, what's happening?!
Click to expand...

This is normal behavior if you are attempting to sort or group on the memo
fields, or are applying any sort of format to them. Also if you are using
the DISTINCT clause. A plain-vanilla SELECT query should return the entire
memo field.
 
Back
Top