Compare two fields

[funkygoorilla]

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.

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

[pdebaets]

Try this:

If strcomp("" & Me.pwFirst, "" & Me.pwSecond, vbBinaryCompare) = 0 And Len(Me.pwFirst & "") > 0 Then

[funkygoorilla]

Hi, thanks for the code. That works as I would like it. The only thing is that even if the two "password" dont match, when you click the save button, the second password gets saved into the table. Is there a way to have it save only if the two are equal?