Credit Card Imput Mask

[Rich1968]

I accept Credit Cards Over the Phone. I send a receipt to the Customer with the entire CC Number xxx Out. I want to set up an Input mask in my receipt report that will only x out the first 12 numbers. Like this:

XXXX-XXXX-XXXX-9999

I have try several times to accomplish this.

Any help would be appreciate!

Rich

 

[pdx_man]

I believe this is posted in the wrong forum.

What you are looking for is not an Input Mask, but rather a how the data looks on a report. When the user inputs the CC #, they will need to see the entire number. Try this ... Let's assume the field where the CC # is stored is called CC_Num. In the control source of a text box on a report, have:

="XXXX-XXXX-XXXX-" & Right([CC_Num],4)

On the input form you can have an Input Mask of something like:

0000\-0000\-0000\-0000;1;#

This will ensure that you input all of the numbers required.

 

[Rich1968]

Hey PDX,

Thanks for the help! It worked great!

Rich

 

[Rich1968]

Tony,

That would be great!

Thanks
Rich