Long text field

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
 
V

Vera

Mark,

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

Vera
 
D

Duane Hookom

If it get truncated in the query, this is usually caused by phrases in the
sql such as "DISTINCT", "DISTINCTROW", "GROUP BY",...
 
A

Amanda Brus

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?
 
Top