Hiding Social Security Number in form

jeudi 30 avril 2015

Hi all,

This should be relatively easy although I seem to have forgotten a lot since the last database I completed. I have looked through several examples online and I am lost. :confused:

On my form frmEmployeeDetails I have a text field that is named SSN for social security numbers. I have used the mask on it so it automatically inputs dashes. I am attempting to hide all but the last four digits of the ssn. This is on the on current event of my form.

Code:

'Hide SSN
Dim strLSSN, strSSN As String
strLSSN = Right(SSN, 4)
strSSN = ("***-**-" & strLSSN)
Me.SSN = strSSN

Any help is greatly appreciated, Thanks!
Samantha
Hiding Social Security Number in form

0 commentaires:

Enregistrer un commentaire

Labels