HELP again!! -- Regular Expression

[Guest]

Hi,

I'm using Access 2000. Had search all over, but couldn't find stuff that say
regular expression in vba..

I trying to write a function, which has a input string(values are parse over
from a table in Access).
That will go thru a regular expression to check if a set of alpha is present.
If true, will set another column of the table with the set of alphs.

I been getting a lot of error meeages, couldn't find the right Object to use
for Regular Expression.

Can some one pls tell me which object to use in order to have regular
expressions?? Or how to programme the function in the right way..

Pls help me...

Thanx a Million...

RegarDx..

 

[Douglas J Steele]

Take a look at my October, 2003 "Access Answers" column in Pinnacle
Publication's "Smart Access". You can download the column (and sample
database) for free from http://www.accessmvp.com/DJSteele/SmartAccess.html