change field to "password" type

[ducecoop]

Access 2003

Right now I have a DB that collects usernames and passwords.
Only a couple have access to the DB however even some of those few people shold not be able to read ALL passwords.
They need to read most to do their job but in a few case they should not see them.

so I am doing this:

Private Sub Form_Open(Cancel As Integer)
If Me.Privacy = True Then
Me.ComputerPassword.Visible = False
Me.EmailPass.Visible = False
End If

End Sub

it just makes those to fields hidden when the privacy field is checked.



I would prefer to see the field displayed like a password field is (with *****) when Privacy is true.

Is this easily doable?

Dave

[pbaldy]

Try

Me.TextboxName.InputMask = "Password"

[ducecoop]

Try

Me.TextboxName.InputMask = "Password"

Its a beautiful thing

Thanks so much

[pbaldy]

No problemo!