Find and Replace Paragraph

[Basia]

Greetings.

I would like to set up a button on my form that cleans up white space on a memo field. The TRIM function does not clean up Paragraphs or carriage returns. Could someone tell me how to use Find and Replace or SUBSTITUTE?

Thanks,
Basia

 

[KellyK]

Basia,
What about setting the 'can shrink' property to Yes?

Kelly

 

[Basia]

Hi Kelly:

Thanks for the quick response. The can grow/shrink properties are on. I am going to try to figure out the Chr number and do a replace.

Thanks again,
Basia