Password Criteria Validation

[rpferguson]

I have a database I am working on that allows a user to change or reset their password. This portion is not the issue, but I would like to be able to make sure that their password contains at least one upper case letter, one number and one special character before it gets encrypted and written to the table.

I know I can most likely set this up by going through the entire string character by character validating ascii characters by value, but I was wondering if anyone knows of an already exsisting function or method that would allow me to do this through VBA.


Thanks for any assistance.

 

[deBassMan]

I know of no existing function but going through the entire string character by character validating ascii characters by value is def the way to go.

good luck

 

[rpferguson]

thnx. I didn't think so. I'll post my VBA functions when they're complete.

 

[pbaldy]

You could use regular expressions, if you want to poke around and find the one that best fits your needs.