field data too long?

  • Thread starter Thread starter test guy
  • Start date Start date
T

test guy

I've got a long number populating a field, and on the form, the field shows
"1.031568539E+09" or similar instead of the number... how do I need to set
the values of this field so it shows just the number?
 
I've got a long number populating a field, and on the form, the field shows
"1.031568539E+09" or similar instead of the number... how do I need to set
the values of this field so it shows just the number?
Click to expand...

That *IS* the number, in "scientific notation". To see it as an
enormous integer (limited to 13 or 14 digits due to the size of a
Double number type) just make the form textbox wider.

If it's an identifying number (something that you will never use for
calculations), I'd suggest storing it in a Text field instead of a
Number field of any type.
 
Back
Top