MS Acess Cannot Distinguish Between Capital and Small Letters

[ahd2008]

Good day all,

I am creating a new from for the purpose of allowing the Admin(s) to create new users. There is a filed for the password and another one to confirm the password. However, MS Access doesn’t seem to be able to distinguish between capital and small letters. For instance, if the password field contains “Smith” and the confirm password field contains “smith”, the below code wouldn’t work.

If Me.Password <> Me.ConfirmPassword Then
            MsgBox "The passwords are not matching", vbOKOnly, "Required Data"
            Me. ConfirmPassword.SetFocus
        Exit Sub
    End If 
 
 

[TheSmileyCoder]

Hi

Its not a question of "cannot". Its a concious thought out design choice from the developers.

If you wish to make a different comparision, you can define a function in a seperate module like so:

Option Compare Binary
Option Explicit
 
Public Function bCompare(strInput1 As String, strInput2 As String) As Boolean
 bCompare = (strInput1 = strInput2)
End Function
 

Note the Option Compare Binary at the top of the module. That makes Access for the code in this module, use binary comparison.

[TheSmileyCoder]

I also just remember that access has a built in function for this. I just couldn't remember the name of it at the time of my first post.
Syntax:

StrComp(string1, string2[, compare])

For the optional compare variable, use vbBinaryCompare.

[ahd2008]

Thanks brother for your glorious efforts. Apprecciate your help

Regards,