credit card number security

[Guest]

I am setting up a new employee database and need to be able to mask off all
but the last four numbers of a credit card number entered. For example, when
the credit card number 1234-5678-9012-3456 is entered in a field, it would
display as ****-****-****-3456. Any hints, tips or tricks would be greatly
appreciated.

 

[Rick B]

I would not recommend using Access to store credit card numbers. Access is
NOT secure.

 

[Guest]

Regardless of the security issue, is there a way to accomplish what I am
asking?

 

[Rick B]

Well, typically, you would not mask it as you were entering it. You need to
be able to see it so you can identify typos. Where you would want your mask
is in any displays or reports. To do that, you could create some code, or a
combined field using the "*" character and the MID or RIGHT function to grab
only the RIGHT four digits.

For example...

= "****-****-****-" & Right([SomeCCFieldNAme],4)

 

[Larry Daugherty]

MyText = "****-****-****-" & Right([ CCNumber],4)

HTH