Make Double field not scientific

  • Thread starter Thread starter Matthew
  • Start date Start date
M

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
 
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.
 
I have an Access Database that stores credit card numbers in a numeric
double field.
Click to expand...

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