Hiding Credit Card Details

[Guest]

I have a form which displays our customers details and one of them is there
credit card number. I would like to change what is displayed for tyhe card
number from 1234-5678-9012-3456 to ####-####-####-3456. I beleive it is
something to do with the format control on the form but I can't for the life
of me figure it out.

Any assistance would be greatly appreciated.

 

[strive4peace]

Hi shannon,

InputMask --> Password


Warm Regards,
Crystal
Microsoft Access MVP 2006

*
Have an awesome day

remote programming and training
strive4peace2006 at yahoo.com

*

 

[Keith Wilby]

I have a form which displays our customers details and one of them is there
credit card number. I would like to change what is displayed for tyhe
card
number from 1234-5678-9012-3456 to ####-####-####-3456. I beleive it is
something to do with the format control on the form but I can't for the
life
of me figure it out.

Any assistance would be greatly appreciated.

You really don't want to be storing sensitive information like this in an
Access database! I'd be extremely unhappy if any of my numbers were in one
and if someone was to steal your data and use it for criminal activity you
may be liable for the consequences.

Regards,
Keith.
www.keithwilby.com

 

[John Spencer]

Set the display format to
"!####-####-####-@@@@"

And don't let anyone into the control (locked and not updatable)

 

[Guest]

The Password Input Mask won't quite do it. Note the last 4 digits need to be
displayed. To use this technique would require 2 controls. This would be a
hassle.

Another way using two controls and being able to keep the entire number
together would be to have one bound control for the number that is Visible =
No and an Unbound control to do the display and entry.
Use the unbound control's Change event so that as a digit is entered, the
Change event would add the digit to the bound control and replace it with a #
in the unbound control, except for the last 4 digits.

 

[Guest]

Is there a reason that the form needs to show the CC# and other sensitive
data to anyone other than the customer? I'm asking as you really do not want
to be storing this information in an Access database. It's like storing
their SSN. It needs to be locked and not updateable, not reportable.

 

[strive4peace]

Thanks, John -- I missed the part of his post that said he
needed to show the last 4 characters -- reading too fast I
guess!

Warm Regards,
Crystal
Microsoft Access MVP 2006

*
Have an awesome day

remote programming and training
strive4peace2006 at yahoo.com

*

 

[strive4peace]

thanks, Klatuu -- I missed that part...


Warm Regards,
Crystal
Microsoft Access MVP 2006

*
Have an awesome day

remote programming and training
strive4peace2006 at yahoo.com

*

 

[Guest]

The credit card details are already there, I am trying to make sure that they
are not available to everyone who has access to the front end, and this is
the first step in that process. The reason for leaving the last four numbers
visible is so when a customer rings and asks for a payment to be put through
on their credit card the person taking the call doesn't see all the details,
but can at least confirm the last four numbers.

I have made sure the field is locked and not updateable.

Thanks to everyone for their help.