Upper case in passord

[Khalil Handal]

Hi,

I have a user form to enter a password.

 If txtPassword = "Loka4" Then
        DoCmd.OpenForm "formName"
else
MsgBox "Invalid Password. Please Try Again", vbOKOnly
end if

If the user types loka4 or Loka4 the form opens.
What do I have to do so that the form will open only of Capital L is used.
Form opens if Loka4 is entered.

Khalil

[moke123]

Use the strComp() with the binary compare argument for the password.
That will make it a case sensitive comparison.

https://www.techonthenet.com/access/...ng/strcomp.php

If strComp(txtPassword,"Loka4",0) = 0 Then ...

or

If strComp(txtPassword,"Loka4",vbBinaryCompare) = 0 Then ...

[Khalil Handal]

Thanks a lot.
It worked.

[moke123]

Your welcome.
Good luck with your project.