Problem with Match case

[accessnewb]

Hi,
I have a password change form in which the user will enter the old password, the new password and the confirm new password. The code works fine, but the only problem is even if the new password and the confirm new password cases are different it will still accept it.

For example, if the new password is "password123". In the new password field I enter "PASSword123" and in the confirm new password field I enter "passWORD123", then it still accepts it and changes the password in the database.

The particular line of code is:

If Me.txtNewPass.Value = Me.txtConfirmPass.Value Then
blah blah

I know that there is a function called matchcase(). But I am not sure how to use it. I couldn't find anything useful online



Any thoughts????

[boblarson]

Actually it is strComp that you want.

If strComp(Me.txtNewPass, Me.txtConfirmPass, vbBinaryCompare)= 0 Then

It equals 0 if it matches

[accessnewb]

Thanks! It works