How to replace start-of-line or end-of-line in VBA editor

[dsaddan]

Hi:

Here is a question that gas been nagging me for ages:

Suppose that you are working in the Access VBA editor.
You need to change this text:
A
B
C

into this text:
"A", "B", "C"

Is there a way to do it with the Find-And-Replace (Control+H) functionality?
To put it in other words:
If you select "Use Pattern Matching" then you can enter wildcards into the "Find What" field, but how do you indicate start-of-line or end-of-line?

Thanks,

Dror

 

[jdraw]

see http://bytes.com/topic/access/answers/943010-what-vbcrlf

 

[dsaddan]

Thanks, but it is not an answer MY question, but to another question.

I was asking on how to indicate the end-of-line in the Find or Find-And-Replace screen.

If you enter vbCrLf in the "Find What" field the editor will search for the string "vbCrLf" and NOT for the end-of-the-line chars (= \r\n)

Dror

 

[pr2-eugin]

I think we had a similar discussion regarding this topic a few days ago.. I am not sure if the OP had solved the issue, but seemed like a great start..