Unusual error message

[Emmanuel]

I kind of noticed a error message in one of my database fields which is in a currency format.


When I enter a large amount, It gives me this prompt.
Is there something I may be getting wrong?
Guys, do advice me…

[Micron]

How large? You should be able to have a number with 15 digits to the left of the decimal. Currency format is one thing - currency data type is another. I suspect your field is not currency data type, or if it is you are doing something wrong, such as trying to enter text, empty string or something else that isn't compatible.

[Emmanuel]

How large? You should be able to have a number with 15 digits to the left of the decimal. Currency format is one thing - currency data type is another. I suspect your field is not currency data type, or if it is you are doing something wrong, such as trying to enter text, empty string or something else that isn't compatible.

Yeah
I’ve noticed the field has a 15 digits to the left of the decimal. Does that mean it can’t go beyond the 15 digits?

[Emmanuel]

How large? You should be able to have a number with 15 digits to the left of the decimal. Currency format is one thing - currency data type is another. I suspect your field is not currency data type, or if it is you are doing something wrong, such as trying to enter text, empty string or something else that isn't compatible.

The issue occurs when I go the 16th digit.
Or should the 15 digits be enough?

[davegri]

Or should the 15 digits be enough?

Should be enough. To paraphrase Senator Everett Dirksen, "A few hundred trillion here, a few hundred trillion there, pretty soon you're talking about real money!"

[Micron]

Or should the 15 digits be enough?

You need to tell us? You are dealing with dollar amounts greater than 999,999,999,999,999.00 ??

[Emmanuel]

You need to tell us? You are dealing with dollar amounts greater than 999,999,999,999,999.00 ??

Kind of thinking if we had some amounts beyond it.
But I think it should be okay.

Thanks

[Emmanuel]

Should be enough. To paraphrase Senator Everett Dirksen, "A few hundred trillion here, a few hundred trillion there, pretty soon you're talking about real money!"

Alright Sir. Thanks so much