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

  • Thread starter Thread starter its O.N.
  • Start date Start date
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!!!
 
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.
 
Back
Top