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?
 

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

Link a text box based on drop down box with four options MS Word 365 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Creating a Chart on form from selected data in query. 0
How to have two tables on same line? 1
How to paste this down? 3
Formating bolded text exclusively. 0
Excel does not accept text format! 0
Weekly Report 2

Top