I am utilizing a very simple solution for masking social security numbers. I know there is a much more secure method of utilizing encryption with keys that Richard has covered somewhat recently. I don't care to do anything like that. I just have a text field over the actual social security number with the following code:
=("***-**-" & Right([SSN],4))
Once this textbox is clicked, the focus is set to the actual social security number field to reveal the rest of the social security number. This masked field is sort of the same idea Richard uses for cascading comboboxes in a continuous list form.
The only problem with this solution, aside from it not being the most secure solution (only protecting from shoulder surfing) is I can't manage to figure out how to use an Nz function disable the "***-**-" mask when the field is null.
I feel kind of stupid not being able to figure out how to "" a part of a concat string.
Thank you very much! I was trying to get it to work with every possible combination of Nz - I feel kind of stupid that I didn't even think about the IIF function.
Thanks again!
Sean SweeneyOP
@Reply 4 years ago
Hey Kevin - Thank you very much for the idea! This is is a really good idea for making a subroutine! This makes a lot more sense than a "forward" / "behind" solution I'm using with an on-click set-focus function. I thought I was being clever, making a set-focus on-click, but this method is a much more elegant solution.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Beginner 6.
