I'm not sure how to go about this. I have to enter credit card numbers into an Access database. They can be AmEx, MC, Visa or Discover. I'd like to create an input mask so it's easier to enter/view. However, the formats are different. For AmEx, the format is ####-######-##### (4-6-5). For the others it's ####-####-####-#### (4-4-4-4). Is there a way to create a mask that looks at the first number entered and formats the mask based on that? For example, if the user enters a 4, it knows that is should apply the VISA mask. If a 5, the MC mask. If a 3, the AmEx mask. And if a 6, the Discover mask.
If not, another alternative is that I could have the user indicate the credit card type in field 1 and then enter the credit card number in field 2. Can I get the mask formating of field 2 to read the value in field 1 and apply the appropriate mask?
Also, if anyone can confirm the format (4-4-4-4) and starting number for Discover card, I'd appreciate it. I can't seem to find anyone who has a Discover card...
Thanks!
Anna Jaeger
iMIS Database Support
If not, another alternative is that I could have the user indicate the credit card type in field 1 and then enter the credit card number in field 2. Can I get the mask formating of field 2 to read the value in field 1 and apply the appropriate mask?
Also, if anyone can confirm the format (4-4-4-4) and starting number for Discover card, I'd appreciate it. I can't seem to find anyone who has a Discover card...
Thanks!
Anna Jaeger
iMIS Database Support