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?
 

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

cannot remove reminders 8
Print outlook contacts with all notes intact. 1
text box in report is truncating memo field at 255 characters 2
Memo field truncating in report 3
how to find out if text in the Excel cell will be trancated? 2
Report control doesn't display all the characters in a query field 2
Memo field cuts text 1
How do I force a memo field to print all text in reports? 2

Back
Top