Password Verification Form...

[PerryC]

All,
This should be very simple for you VB programmers, I am just a
beginner and am stuck! It should be very simple... what am I not
doing right?

Dim PW As String

PW = Me.Password

If PasswordVerify <> Password Or IsNull(Password Verify = True)
Then
MsgBox "Password you've entered do not match. Please Retype."
Me.PasswordVeri fy = ""
[Password].SetFocus
Me.Password = PW
Else: MsgBox "Your new password has successfully been set."
End If
I have 2 boxes, "Password" and "PasswordVerify ". Password box is
based on a Table while PasswordVerify is just an unbound box. If user
enters an password that do not match, it will revert back to its
original password. I named it PW. But apparently, me.password = pw
did not do so. What did I code wrong?

Thanks.
PC

[Bob Quintal]

pe******@yahoo. com (PerryC) wrote in
news:ea******** *************** **@posting.goog le.com:

All,
This should be very simple for you VB programmers, I am
just a
beginner and am stuck! It should be very simple... what am I
not doing right?

Dim PW As String

PW = Me.Password
The next line of code is bad. If PasswordVerify <> Password Or IsNull(Password Verify =
True)
Then

it should be:
If PasswordVerify <> Password Or IsNull(Password Verify)

because
(PasswordVerify = true) can never be null.

You'd simplify everything however but inverting the logic

If me.Password = PasswordVerify then
msgBox "Your new password has successfully been set"
else
msgBox " whatever"
me.PasswordVeri fy = null
me.Password.set focus
me.Password = PW
End If

Note password = passwordverify will be false if either side is
null. That makes the whole thing easier to manage.

Bob Quintal

MsgBox "Password you've entered do not match. Please Retype." Me.PasswordVeri fy = ""
[Password].SetFocus
Me.Password = PW
Else: MsgBox "Your new password has successfully been
set."
End If
I have 2 boxes, "Password" and "PasswordVerify ". Password box
is based on a Table while PasswordVerify is just an unbound
box. If user enters an password that do not match, it will
revert back to its original password. I named it PW. But
apparently, me.password = pw did not do so. What did I code
wrong?

Thanks.
PC