Only 255 character appearing in memo field

[SunWuKung]

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

 

[joeyreyma]

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

 

[SunWuKung]

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

 

[SunWuKung]

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...

 

[Rich]

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.

 

[joeyreyma]

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).]

 

[SunWuKung]

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.

 

[russi]

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