Samantha
still learning...
- Local time
- Today, 18:31
- Joined
- Jul 12, 2012
- Messages
- 182
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.
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.
Any help is greatly appreciated, Thanks!
Samantha
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.

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
Samantha