Enter line feed in Search+Replace?

[Michael Peters]

is there a way to replace a certain sequence of characters by line feed
(vbCrLf ), for all text columns in a table, using Search+Replace?

-Michael

[Anthony England]

"Michael Peters" <[e-mail]> wrote in message
news:dq*************@news.t-online.com...

is there a way to replace a certain sequence of characters by line feed
(vbCrLf ), for all text columns in a table, using Search+Replace?

-Michael

No, you would have to write the code yourself, or manually carry out update
queries on the text fields. The update queries would look something like
that below:

UPDATE MyTable SET MyTable.MyField=
Replace([MyField],"<NewLine>",Chr$(13) & Chr$(10),1,-1,1)
WHERE InStr(1,[MyField],"<NewLine>",1)>0

[Michael Peters]

> The update queries would look something like that below
thanks Anthony, looks good, I'll try that.
-Michael