How do I create an Access form that blocks 1st 5 #s of SSN?

I

its O.N.

for example: xxx-xx-1234 - but in the table you would see the SSN in full
(123-45-6789) - this is for security so people view FORM would not see
complete SSN? Thank you very much!!!
 
D

Douglas J. Steele

Create a query that uses something like "xxx-xx-" & Right([SSN], 4) instead
of SSN, and use the query wherever you would otherwise have used the table.
 
Top