Credit Card Encryption Report

  • Thread starter Thread starter AJ
  • Start date Start date
A

AJ

I want to print credit card numbers out in the following
format on our invoice ****-****-****-4792. Currently it
shows the full number 1234-1234-1234-1234. Thanks.
 
If your are getting the Credit card number from a SELECT do the followin

SELECT '****-****-****-' + RIGHT(Tarjeta, 4) AS credit_car
FROM TABLE_WHERE_CREDIT_CARD_I

that's what i would do
 
AJ said:
I want to print credit card numbers out in the following
format on our invoice ****-****-****-4792. Currently it
shows the full number 1234-1234-1234-1234. Thanks.
Click to expand...


Can you just set the text box's control source expression
to:
="****-****-****-" & Right(cardnum, 4)
 
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Try using this in the query that supplies the report:

SELECT "****-****-****-" & Right(CreditCard,4) As Crypt_CC
FROM TableName
WHERE ....

The use of the mask "****-****-****-" and the Right() function on the
CreditCard column will produce your required results. This assumes
the CC is stored as "####-####-####-####", i.e., it has the dashes
between the number groups and each number group has 4 numbers.

I suggest you put the formatting in the query because it hides the
number at the source (server) rather than in the report (which someone
may be able to open in design view, run the report's query & see the
real CC #.

HTH,

MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQDZNJIechKqOuFEgEQKdPwCfQP69cjNiIA6f6Y0Yu7JhlEoPwTkAn2kb
fTtUhaR+E6wW55EmYU1l5DTh
=hroZ
-----END PGP SIGNATURE-----
 
Back
Top