Credit Card number in form

[SJL]

Hi
I have a form where a creditcard number needs to be entered into a form. The
report will then be converted to Excel 97-2003 format and imported. My
problem is that when I have changed to property of report from .rtf to .xls
the CC filed no longer accepts the cc number. I get the error message "the
value you have added is not valid for this field" I'm suspecting that I need
to change the properties in both the tabel and form, but to what? ( The CC
number is 15 digits long)

Thanks

 

[Wayne-I-M]

Credit card numbers are "text". Format your table field as text.

Note - a number is (as far as I know) anything that can be added together to
create a sum value. So credit card number are not numbers they are text.

Hope this helps

 

[SJL]

Hi Wayne

Thanks.

Credit card numbers are "text". Format your table field as text.

Note - a number is (as far as I know) anything that can be added together to
create a sum value. So credit card number are not numbers they are text.

Hope this helps