I have a table with a memo field. They usually contain more than 255 characters. I checked it and in the table they are correct.
However when I produce a report on it only the first 255 character appears from the memo field.
I am using a text box to display them in the report. Should I use something else, does it have a property that I didn't find?

Could somebody help me?

Thanks.

SWK

try to set the CanGrow and CanShrink properties of the textbox to YES

they are set to yes. I also tried to create real large text boxes for the memo but no luck

Jee, I found the answer, and it is weird.

If it goes trough a query that has Total in it, it gets chopped down to 255 characters. Queries withouth Total are OK.

Now what do you say to this...

You can't use memo fields in a totals query, I'm suprised access didn't give you the custom error when you tried to do so.

really wierd, all this years i have'nt meet that kind of problem since i thought you cannot make total query with memo field or ole object in it so i have'nt tried.

[This message has been edited by joeyreyma (edited 07-05-2001).]

Well, DevTipText is the Memo field.
This is the query that only returns 255 character from that field:

SELECT DevTips.DevTipText
FROM DevTips INNER JOIN (Comp_temp_select INNER JOIN DevTips_toComponents ON Comp_temp_select.AutoID = DevTips_toComponents.CompAutoID) ON DevTips.ID = DevTips_toComponents.DevTipsAutoID
WHERE (((Comp_temp_select.Selected)=True))
GROUP BY DevTips.DevTipText, DevTips.ID
ORDER BY DevTips.ID;

And this is the one that returns all characters.

SELECT DevTips.DevTipText
FROM DevTips INNER JOIN (Comp_temp_select INNER JOIN DevTips_toComponents ON Comp_temp_select.AutoID = DevTips_toComponents.CompAutoID) ON DevTips.ID = DevTips_toComponents.DevTipsAutoID
WHERE (((Comp_temp_select.Selected)=True))
ORDER BY DevTips.ID;

No error message with either of them. And in grid view the only difference between the two is the Total row on or of. I run the query toggle Total and I can see the end of the Memo disappearing.

I had a similar problem before and the answer was that I had the '>' symbol in the Format property of the memo field in table design view. (I had wanted the data entry to show as all capital letters.)
Once I took that Format property out, deleted this field on the form and re-put it in, the problem was gone.

Russ