Format CC# to show only last 4 digits

[ledmark]

Hello - I have built a database that holds vehicle information. Each vehicle has a credit card assigned to it. Is it possible to put in an input mask or format the field so that the first 12 digits are hid but the last four show:

****-****-****-5555

There will be more than one person entering data and only one person should have access to the credit card numbers. They don't want everyone to see the whole number.

I've found this:
Format Specified: "Acct No." 0000
Data As Entered: 3271
Formatted Data as Displayed: Acct No. 3271

When I try to put this in the format space it changes when I get out of it to this:

"Acct No. "0000

and it won't come out the way it's supposed to.

Any help would be greatly appreciated.

Thank you
Laura Edmark

 

[Banana]

You want to tinker with Input Mask, not Format; Input Mask alter and can hide how you present the data while format actually alter the data itself.

The trouble, though, is that I don't think (though my curiousity is piqued; will have a tinker) that you can specify a partial password mask. One workaround would be to create four textboxes, and use Password mask for the first three textboxes, set their validation to not exceed four character and must be digits only, and leave the fourth textbox without the input mask but with same validation rule.

 

[gemma-the-husky]

you could always store the cc no (encrypted if necessary)

when you want to display it, (assuming its sixteen digits), you could just assign it to a
string

showstring = "****-****-****-" & right(cstr(truecard),4)

 

[ledmark]

Thank you both for this information - I'll give it a whirl to see what I can work out.

Laura