Regular Expressions

mads68
06-13-2001, 01:31 AM
How can i use regular expressions in Access?

Bigpapou
06-13-2001, 09:01 AM
What do you meen by regular expression?
If-Then, Do-loop, thing like that or something else?

mads68
06-14-2001, 02:56 AM
no, i meant a expression like:
regEx.Pattern = "^[a-zA-Z][\w\.-]*[a-zA-Z0-9]@[a-zA-Z][\w\.-]*[a-zA-Z0-9]\.[a-zA-Z][a-zA-Z\.]*[a-zA-Z]$"
to validate an email. But the solution was to make a reference to "Microsoft VBScript Regular Expression"

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum