Regular expression and ....

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I asked this question last week but so far it remains unanswered (or it was
answered some where that I can not find.)
I need to modify the content of a "memo field" by searching for a "number
followed by a period like "1."" and then adding a new line before the number.
Otherwords,
creating numbered lines out of a very long memo. I do not know if "new line"
character can be added in a memo field in access or not. If it can be done
then what would be the vba code to do this?
Moe
 
In order to ener the line break you need to use Chr(13) & Chr(10)

I am not sure how to search for regular expressions in VBA, but you can use
instr to find the location of specific text and then concatenate the string
around the line break.

Let me know if this was helpful and if you can use more assistance.
 
Back
Top