Hi,
I have two fields that I am using as a means of password verification for users who would like to change their passwords in my DB. I need to know if it is possible to have the two fields check for case sensitivity? Currently, if you put arizona in field A, and Arizona in field B, then Access will accept it and over write their current password. Below is my Save button On CLick Event. I obtained this with the help of a member name June7. Any info or tips would be greatly appreciated.
Code:
Private Sub btnSave_Click()
If Me.pwFirst = Me.pwSecond And Len(Me.pwFirst) & "" > 0 Then
DoCmd.RunCommand acCmdSaveRecord
DoCmd.Close acForm "frmChangePasswordtest"
DoCmd.OpenForm "frmMainMenu"
Else
MsgBox "New Password entries do not match. Re-enter ." _
& vbCrLf & "and please try again.", vbCritical, _
"Re-enter both Passwords."
End If
End Sub