Credit Card Validation

[rkulik]

Anyone know how to validate a field that contains a credit card number? Using the after update event?

 

[Peter D]

What kind of validation do you want to do?

If you just want to validate that it's numeric, and has a certain number of characters, use the BeforeUpdate event proc.

Hope this helps,

Peter De Baets
Peter's Software - MS Access Tools http://www.peterssoftware.com

 

[charityg]

if you mean validate the actual number, I have the script somewhere that can validate whether a credit card number is an actual Visa, Discover, Mastercard, ect. number. Then it checks the expiration to assure that the card isn't expired. I don't have this in VB or Access code however, because I never needed it, but the formulas are pretty easy to figure out.

 

[rkulik]

Just so the number is not keyed in incorrectly. Some sort of validation would be nice

 

[Rich]

Can't you use a custom input mask?

 

[DES]

Just finished making a sample - email me if your interested.

 

[skiphooper]

Hi Des,

Another nice Sample,
Thanks For Sharing

Skip