Social Security in Table and Reports

[wes9659]

Does anyone know how I can generate just the last 4 digits of the SSN need to be shown on the reports which are generated? For example if a SSN were: 123-45-6789 I would want the field to read ***-**-6789. I also would like to have actual row in table password protected on its own is this possible? Thanks Everyone for your time and consideration I this matter.

[John_G]

Hi -

For the display question, you could use something like "***-**-" & mid(ssn,8), which isn't using a mask, but looks like it is. It does assume that your SSN field is string type, with all values formatted the same way.

As far as I know, you cannot apply a password to just one table row (what would it be based on?) using built-in MS Access features, but you might be able to use VBA to do it. It would depend on what the restriction was to do, i.e. change or view data.

HTH

John

[NTC]

"***-**-" & Right([ssnFieldName],4)