how do i hid credit card numbers in access

G

Guest

i have a for that i enter in cc numbers i want to be able to store the actual
number but on my report sho an x for the first 12 digits
 
A

Allen Browne

Not all credit card numbers are 16 digits, but try:
=String(12, "x") & Right([cc], 4)
 
D

Debra Farnham

Try:

Create an unbound textbox on your report and set its control source to:

=String(12,"*") & Right([nameofcreditcardfield], number of digits you wish
to show at the end of the credit card number)

ie. if I have a credit card number of 4532 562 123 4562 in a field named
CreditCard and I use

=String(12, "*") & Right([CreditCard], 3), the result in the textbox would
be ************562

HTH

Debra
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Amazon not accepting Visa Credit Card for payment from January 2022 20
Credit Score 5
OnePlus January 19 Credit Card Security Update: up to 40k customers may be affected 2
Enter credit card number in a cell 2
How do I do display xxx-xx-1234 in an access report 10
Credit Card number in form 2
Typing a credit card number in a cell 3
Excel 2003: Cell rounds 16 digit numbers- How to advoid rounding? 1

Top