Messed up with memo field!!!!

[jinglin]

It's Friday!!!

I'm not sure if there're any one who can help me out with this problem.
Some of my users entered the data into the field (memo datatype) with lots of empty lines in between.

such as:
blablabla----the first line


blablabla----Second line

blablabla----third line
So, is it possible that I can get rid of the white lines programmatically and let all sentences line up nicely. Otherwise I have to do it manually.

Appreciate your help. Thanks

Jinglin

 

[PHV]

Something like this ?
theMemo = Replace(theMemo, vbCrLf & vbCrLf, vbCrLf)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[jinglin]

I'll try and let you know if it works!
Thanks!

Jinglin

 

[jinglin]

Somehow, I can't find the function called replace().
Is it a user-defined?
Thanks

 

[PHV]

You should have ac2k or above.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244