Long text field

  • Thread starter Thread starter Vera
  • Start date Start date
V

Vera

Hello!

I've got this problem with a memo field that displays in
full in a table, but gets trancated in a (select) query
and in a report, based on this query.

Is there a way I can prevent the trancation of the text?

Many thanks,

Vera
 
Mark,

Both Can Grow and Can Shrink properties are set to 'yes'!
That was the first thing I checked .

Vera
 
If it get truncated in the query, this is usually caused by phrases in the
sql such as "DISTINCT", "DISTINCTROW", "GROUP BY",...
 
I'm having the same problem with the memo field
truncating in a report. I've tried everything to fix this
including marking "yes" by the "Can Grow" field in
properties. I've figured out that my query which pulls my
memo field is maxed out at the total 255 characters
Access allows in a query. Any way to get around this?
 
Back
Top