Inserting a memo into a visible box

[ejmiller2]

I have a field that is condsiderd a "memo" type of string. This means im allowed to put in more than 255 characters into the field...or so i thought. I now want to display this field in the report but have no means of doing this. If i use a list box i can only fit so much on the page because the text doesn't wrap to the next line. Is there anyway i can do this??....i hope so, or else it seems this memo type of variable doesnt seem very vaild. thanks all
eric

 

[dhookom]

A normal text box with no value in the format property but with the Can Grow property set to yes can accommodate much more than 255 characters. If this doesn't seem to work for you then your issue is probably in your report's record source query. Make sure you don't have words like "DISTINCT" or "GROUP BY".

Duane
MS Access MVP