ghost digit

[Guest]

when I enter 6125552365231728 in a cell of my database the last digit changes
to zero (0) ???

 

[Dirk Goldgar]

when I enter 6125552365231728 in a cell of my database the last digit
changes to zero (0) ???

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).

 

[Arvin Meyer [MVP]]

when I enter 6125552365231728 in a cell of my database the last digit changes
to zero (0) ???

That number will only fit into a Double datatype and it will be changed to
scientific notation:

6.12555236523173E+15
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Guest]

That number will only fit into a Double datatype and it will be changed to
scientific notation:

6.12555236523173E+15
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

thank you !!!

 

[Guest]

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

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!!

 

[Dirk Goldgar]

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!!

"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.