Password VBA

[k_fish]

I am writing a Program with Visual Basic Editor which needs to have a Form (which has been created) with a password textbox and a Confirm Password Textbox. What I need is the program to check to see if the passwords are the same, any ideas on how to do it?

 

[bertie]

The strComp function compares two strings, i.e,

   '==========
   'test01
   '==========
   If Not StrComp(Me.TestBox1.Value, Me.TestBox2.Value, vbTextCompare) Then
      MsgBox "Test01 passwords don't match!"
   Else
      MsgBox "Test01 success"
   End If

You need read up on strComp. I can't remember if strComp is case sensitive or if allows special characters, i.e., period, hyphen, etc. The help file wasn't, you know, helpful.

An alternative approach would be to loop through the two string comparing the ASCII value of each character:

   '=======
   'test02
   '========
   pwd01 = Me.TestBox1.Value
   pwd02 = Me.TestBox2.Value
   For i = 1 To Len(pwd01)
      If Asc(Mid(pwd01, i, 1)) <> Asc(Mid(pwd02, i, 1)) Then
         
         'Me.txtPwd01.Value = ""
         'Me.txtPwd02.Value = ""
         
         MsgBox "Test02 passwords don't match!"
         Exit Sub
      End If
   Next i
   MsgBox "Test02 success"

Hope this helps,
Bertie

[EDIT]
If you use Test02 you may need to compare the string lengths:
Len(pwd01) = Len(pwd02)

before the loop starts.