case sensitive compare password when found the id with dlookup

119 Views Asked by At

I want a code to lookup for a username and compare the password ( case sensitive ) using the dlookup here is my code and it doenst care for the pass if it is capital letter nor not

If (IsNull(DLookup("UserName", "UserID", "UserName='" & Me.Userbox.Value & "'and [password] = '" & Me.Passbox & "'"))) Then

Thanks

0

There are 0 best solutions below