**verify password**

[MS_Access_Amature]

How do I make sure two passwords are exactly the same??

I have two fields: MyPassword and MyPassword2.

In order to create and save your password they have to match. But it's letting me save even tho MyPassword is Admin and Password2 is admin??

How do i make it case sensitive??

 

[boblarson]

You either have to change your

Option Compare Database

part of your module to

Option Compare Binary

or you can use strComp to test

If strComp(Me.MyPassword, Me.MyPassword2, vbBinaryCompare) <> 0 Then
   Msgbox "Passwords do not match"
End If

 

[MS_Access_Amature]

Exactly what i needed. Thanks again Bob, you're always saving me!!