modifying a memo field programmatically

[Moe]

Dose VBA have "regular Expression"? if yes then how it works? 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.

 

[Cindy M.]

Hi =?Utf-8?B?TW9l?=,

Dose VBA have "regular Expression"? if yes then how it works? 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.

VBA can only use RegEx by accessing an outside library. I can't remember which
one(s) provide that functionality, but you could try asking in a classic VB
newsgroup, such as

http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.vb.genera
l.discussion&lang=en&cr=US

To use an external library in your project, choose it from the list in
Tools/References.

For the Access-specific part of your problem, best to ask in an Access
newsgroup

http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.access.mo
dulesdaovba&lang=en&cr=US

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail