Prevent printing of carriage return and line feed characters

[Chisamba]

Hi,

How do I prevent the printing of carriage return and line feed characters in a memo field on a report? They appear as a small box.

Thanks

 

[SamDeMan]

in the properties of the field (design view) set it "can grow" to "no"

sam

 

[Chisamba]

Solved the problem. The 'Square box" is the line feed character, so instead of using vbCrLf and then vbLf I used vbCrLf a second time, no box. It beats trying to write code to hunt down the boxes and replace them - I have seen that suggested elsewhere.

Dave