Credit Card number in form

  • Thread starter Thread starter SJL
  • Start date Start date
S

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
 
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
 
Hi Wayne

Thanks.

Wayne-I-M said:
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
Click to expand...
 
Back
Top