On Wed, 17 Mar 2010 07:43:01 -0700, Janie
wrote:

If I set my field size to DOUBLE, I do not encounter the same problem, but I
don't get it. Why do my numbers seem to have a mind of their own with the
SINGLE field size?

The Single datatype does indeed have a range to 10^38 or so... but it only has
24 bits of precision, equivalent to about 7 digits.

If these values are some sort of identifier, i.e. a part number or the like,
and you're not going to be doing any math calculations with them, you would be
much better off storing them in a Text field (with an input mask to force all
digits if that's what you want). This is doubly the case if you want leading
zeroes.
--

John W. Vinson [MVP]