Validate Password Creation with Criteria

[tjb0205]

I want to set requirements for password creation (see example).

Example:
Xray2319! (form entry) Accepted
ray05 (form entry) Rejected

Requirements:

At least 8 characters.
Must contain:
1 Uppercase
1 Lowercase
1 Special Character ( !@#$%^&*` )
1 Digit (0-9)
May NOT contain:
First Name
Last Name
Username
Employee ID

I hope this isn't too confusing. I am relatively new with VBA and trying to learn the best that I can. I have created basic login forms but I have always disliked not knowing a way to implement password requirements.

Note: Using Access 2016

Appreciate the assistance!

[twinnyfo]

tjb0205,

Welcome to Bytes!

You really have two, very distinct and very different questions here. I will split this one thread into two threads, so folks who have questions more similar to one or the other will be able to find them.

This might also help you focus your efforts on one problem at a time--even though these issues are related.

[twinnyfo]

I think the short answer is to examine the User's entered password character by character, see if the characters meet the criteria and when all the criteria are met, then the password is accepted.

You say you are relatively new to VBA, and that's fine. However, we typically don't build the solution for you. We will expect you to have something started that we can troubleshoot with you and help guide you toward a viable solution.

Hope this hepps!

[NeoPa]

Please see my answer in your other thread (How can I Validate a User entered the Correct Password?).

Short answer - just don't do it!