I have a form that request the user to type in the administrator username and password. It searches for the correct password for the administrator. Now if the user name is "AdMiN" and the user types "admin" it will open. I would like the field to be case sensitive. Is this possible?
Here is my code:
Private Sub cmdEnter_Click()
If txtUser.Value = "Admin" And txtPassword = Password.Value Then
MsgBox "Invalid Username or Password!" & Chr(13) _
& "This application will be terminated!", vbExclamation, "Error"
I tried Option Compare Text and it barked at me.
Any help would be great. Thanks