Masking a social sec. no. like this: xxx-xx-5555 1

[BullHalseyUSN]

Friends,

Here is my challenge, and it seems to be one that wraps up many areas of Access expertise but I chose this forum as it seems predominantly to be a forms issue.

The most critical key in my database is the SSN (for overseas folk, it's an identifying no. like this XXX-XX-XXXX).

We have an application here that is sometimes sent through email.

To secure the tables view from prying eyes, I made an Administrator account, set appropriate priveleges and encrypted the tables to secure them and prevent someone from using queries just do to an end-around on me. Good?

Now my challenge is, how can I work my form so that:

Only the LAST FOUR of the social are displayed? (Note that data entry people still have to enter complete 9 digit SSNs).

Thank you for any guidance!

BH

 

[BullHalseyUSN]

Oh! I should add that I use a main form that is used both to display and to enter information. So I couldn't just "pull" the last four only using SQL.

What I mean is I have is something like this:

Bob Smith
phone: 555-555-1212
SSN: 123-45-6799

Each of these text boxes can be edited.

What I'd like to have is:

SSN: ***-**-6799

So, the operator could still change the data if s/he had to.

Is this clear? I'm having a little trouble expressing this!

BH

 

[BullHalseyUSN]

Wow...I knew this was a stumper but I've never had a post that was such a poser. Hmmm. Is this not possible to achieve?

Anyone help a sailor out on Vet's Day?

 

[SgtJarrow]

Why not do the following...

Hide the SSN field you currently have. Add an unbound textbox called MaskedSSN to the form...Using the OnCurrent event of the form, use:

Me![MaskedSSN] = "***-**-" & Right(Me![SSN],4)

This will create the "illusion" you have masked the first five digits....

FInally provide yourself and anyone else that might need to data entry an appropriate way to make the true SSN field visible again...perhaps a hidden command button, or even evaluate the CurrentUser and if equal to Admin, set the true SSN field visible....

****************************
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)

Robert L. Johnson III
MCSA, CNA, Net+, A+
w: rljohnso@stewart.com
h: wildmage@tampabay.rr.com