credit card number verification

[quasimodo]

One of the options of payment I have is by credit card.

How would I verify the entered card number to make sure its been entered correctly?

 

[Mile-O]

Verify the length? Input Mask

 

[quasimodo]

I have that already. I was wondering on how to verify the entered numbers, to make sure they have been entered as they appear on the card.
When a person creates a password, they are asked to enter it twice to make sure its not been mispelled. Would I need the user to enter the credit card number twice to make sure it hasnt been mis-entered in the first place?

 

[Mile-O]

Code like this would work, just put it where you need your db to check the two textboxes.

If Me.txtCardCode1 = Me.txtCardCode2 Then
   ' it was successful
Else
   MsgBox "The card numbers don't match."
End If

 

[quasimodo]

would i put that in the form coding?

 

[quasimodo]

I am confused as to where i should put the code? i tryed having it as an [Event Procedure] for the second text box. I kept getting the message that they didnt match even if they did.

Would I need an extra field in my table for the second text box on the form, or is that just there just for the verification process?

 

[Mile-O]

Here's one method:

 

[quasimodo]

thanks mile-o-phile

could i use the same code on another form which would have other things on it aswell?

 

[Mile-O]

Yep!

 

[quasimodo]

and the control source for the first text box will be CreditCardNo from the table, and the second textbox will be left unbound?

 

[Mile-O]

Yeah, that'll work but:

It might be better to have a third text box with it's Visible property set to no and once the verification has been actioned assign the value of any of the first two textbox's to that textbox.

 

[quasimodo]

thanks...