Mask a text box 1

[snyperx3]

I have a textbox on a form that is linked to a field in a table that contains the ssn of an employee. The record's primary key is the ssn. The problem is, the people entering the data dont need to see the ssn. What we need is for the value of the textbox to remain so it will save the correct data in the table, but i want it to only display the last four digits of the ssn. like in the format: *****1333
The textbox is locked, so they will not be typing in it. I have a lookup for them to find and insert the employee's ssn. So i can update the textbox via VBA.

Is this possible, and if so, how?

-Pete

 

[Remou]

Is SSN numeric or text? SS Number implies numeric, which is harder to format. Perhaps you could set a display textbox to:
="***" & Right([SSN],3)
The 'real' number could be a hidden field.

 

[snyperx3]

thanks for your reply remou. i had actually already solved the problem. but thanks for your answer. it works =]

-Pete