ghost digit

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

when I enter 6125552365231728 in a cell of my database the last digit changes
to zero (0) ???
 
bjl122854 said:
when I enter 6125552365231728 in a cell of my database the last digit
changes to zero (0) ???
Click to expand...

What Field Type and Field Size are you putting that huge number in?
You've probably exceeded the precision of it. You may have to use a
Currency or Decimal field, or else a Text field (if you won't need to do
any arithmetic with the number).
 
Dirk Goldgar said:
What Field Type and Field Size are you putting that huge number in?
You've probably exceeded the precision of it. You may have to use a
Currency or Decimal field, or else a Text field (if you won't need to do
any arithmetic with the number).

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

thanks for the help
Click to expand...
I've tried using general, and currency fileds but have not tried text. I
do not need to work with the # so i could use that. thanks again!!
 
bjl122854 said:
I've tried using general, and currency fileds but have not tried
text. I do not need to work with the # so i could use that. thanks
again!!
Click to expand...

"General" is not a Data Type or Field Size; it's a Format, and so has
nothing to do with the way the field is actually stored. "Currency" is
both a Data Type and a Format -- that is, it can be used to define how
the field is actually stored, or just the way it is formatted for
display, or both -- but since you referred to "General", I suspect
you're looking at the Format property instead of either the Data Type or
the Field Size. It's the data type and size that govern how many digits
the field can actually hold. You can look in the help file for detailed
information about the actual capacity of the various numeric field
types/sizes. However, if these numbers aren't going to be used in
calculations, I think you'll do best just to use a Text field and, if
necessary, use a validation rule to ensure that only numeric digits are
entered into it.
 
Back
Top