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 (=...
I am confused by your code in this section:
For Each Str In strClass
Select Case Str
Case Is = "U"
MsgBox ("Unclassified Absorber") 'print message
Me.chrAbsorptionClass = "Unclassified"
Exit For
...
You stated...
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...