<div>
works perfectly - thank you.<br />
out of curiosity - I was choking on this line using Regexp, any ideas what's wrong with this?<br />
&nbsp; &nbsp;If Len(TestPw) &lt;&nbsp;8 Or RegExpFind(TestPw, &quot;[^a-zA-Z0-9\!\@\#\$\%\^\&amp;<wbr />\*\_\+]&quot;, 1, True) &lt;&gt;&nbsp;&quot;&quot; Or RegExpFind(TestPw, &quot;\d&quot;, 1) = &quot;&quot;&nbsp;Or RegExpFind(TestPw, &quot;[A-Z]&quot;, 1, True) = &quot;&quot;&nbsp;Or RegExpFind(TestPw, &quot;\!\@\#\$\%\^\&amp;\*\_\+&quot;, 1, True) = &quot;&quot;&nbsp;Then<br />
' &nbsp; &nbsp; &nbsp; &nbsp;checkPwd = &quot;Please fix: Password must be at least 8 characters, and include at least one of the following: numeric character, uppercase, and a non-alphanumeric character.&quot;<br />
<br />
RegExpFind is a function by Patrick Mathews you may be familiar with... the fourth parameter = case-sensitive
</div>


works perfectly - thank you.
out of curiosity - I was choking on this line using Regexp, any ideas what's wrong with this?
   If Len(TestPw) < 8 Or RegExpFind(TestPw, "[^a-zA-Z0-9\!\@\#\$\%\^\&\*\_\+]", 1, True) <> "" Or RegExpFind(TestPw, "\d", 1) = "" Or RegExpFind(TestPw, "[A-Z]", 1, True) = "" Or RegExpFind(TestPw, "\!\@\#\$\%\^\&\*\_\+", 1, True) = "" Then
'        checkPwd = "Please fix: Password must be at least 8 characters, and include at least one of the following: numeric character, uppercase, and a non-alphanumeric character."

RegExpFind is a function by Patrick Mathews you may be familiar with... the fourth parameter = case-sensitive

<div>
I put this code in, but it did not do anything? I must have done something wrong
</div>


I put this code in, but it did not do anything? I must have done something wrong

<div>
<div class="content wysiwyg-content">
Dear experts,<br />
I need to validate that a password meets the following criteria - any help is appreciated!<br />
=&gt; Must be at least 8 characters, and include at least one of the following: numeric character, uppercase, non-alpha or punctuation (where not limited by the system)<br />
<br />
Thank you -
</div>
</div>


Dear experts,
I need to validate that a password meets the following criteria - any help is appreciated!
=> Must be at least 8 characters, and include at least one of the following: numeric character, uppercase, non-alpha or punctuation (where not limited by the system)

Thank you -

password validation in Access

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.