Credit Card number in form

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

--
Wayne
Manchester, England.



"SJL" wrote:

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