Delete vbNewLine(s) from MemoField and keep the MemoField format – how

[cuok]

Thanks in advance for any help:

Delete vbNewLine(s) from MemoField and keep the MemoField format – how?

The MemoField looks like this:

INDIA
vbNewLine
vbNewLine
USA
AFGANISTAN
ISRAEL
vbNewLine
BELGIUM

Of course instead of “vbNewLine” there is empty row.

What I need is:

INDIA
USA
AFGANISTAN
ISRAEL
BELGIUM

How can I do it?

thanks again
CUOK

 

[PaulBricker]

Well you can try this in a new column of your query:
MyMemo:Replace(MemoField,vbNewLine," &quot

but I think this will return
INDIA USA AFGANISTAN ISRAEL BELGIUM

Try it and let us know.

Paul

 

[cuok]

Hi PaulBricker 1

Thanks a lot!

You have been right in what i'm getting.
what i'm going to try now is:

Replace(MemoField," ",vbNewLine)

i'll let you know how it goes

regards CUOK