I am doing an order information form in VBA and have an area for credit
card numbers. We take all major credit cards, and so I have the card
number broken up into 4 fields. The idea is that you do not need to
press the tab button to go on to the next field, it will setfocus in a
macro...but is there a way to test for a length of a certain number of
digits in a field? (So if their are 4 numbers in textbox1, then
setfocus textbox2) Right now I am using if then statements to
determine if the number typed in is over 999, but this is flawed for
discover cards, because the 2nd set of digits is usually 0000 for the
number. Any ideas? Please post code example. Thanks