Make Double field not scientific

[Matthew]

I have an Access Database that stores credit card numbers in a numeric
double field.

I access this data with a separate application (Macromedia Coldfusion), and
it returns the credit card numbers in scientific notation.

Do I have to change the field to text, or is there a way around this?

Matthew

 

[Cheryl Fischer]

Matthew,

Is there some specific reason for making the field size a Double? Unless
you are planning to do math with the field containing your credit card
number data, you could go ahead and make it Text data with no ill effects.

 

[John Vinson]

I have an Access Database that stores credit card numbers in a numeric
double field.

Don't. Use Text. You'll never do arithmatic with a credit card number,
and you DON'T want roundoff error!