424,256 Members | 1,253 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,256 IT Pros & Developers. It's quick & easy.

Validate Password Creation with Criteria

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

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


At least 8 characters.
Must contain:
1 Uppercase
1 Lowercase
1 Special Character ( !@#$%^&*` )
1 Digit (0-9)
May NOT contain:
First Name
Last Name
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!
Oct 10 '18 #1
Share this Question
Share on Google+
3 Replies

Expert Mod 2.5K+
P: 2,878

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.
Oct 10 '18 #2

Expert Mod 2.5K+
P: 2,878
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!
Oct 10 '18 #3

Expert Mod 15k+
P: 31,186
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!
Oct 16 '18 #4

Post your reply

Sign in to post your reply or Sign up for a free account.