You are viewing limited content. For full access, please sign in.

Question

Question

Currency Field: Invalid Input Error

Forms Version 9
Updated July 16, 2014
asked on July 16, 2014 • Show version history

I have a currency field that is being populated from a database lookup. In the database it has a value like this 20.48. When it is populated into a currency field, it shows as 20.4800. Not necessarily an issue, but when the Submit button is clicked, it gives an error on the field of "Invalid Input". The Field width is set to small and the Currency Format is set to "USD-US Dollar ($)". It would also be nice to be able to shorten the decimals shown to 2.

1 0

Answer

SELECTED ANSWER
replied on July 16, 2014

Are you using the money column type in SQL? The consequence of that data type is that it uses four decimal places. As an option, you can use the decimal data type in SQL if you want to format the values to contain two decimal places.

1 0
replied on July 16, 2014 • Show version history

That was it. We have multiple fields with dollar amounts in them. All but this one was a nvarchar(255). The one having the problem was a money column type. Corrected that. Thank you!

2 0

Replies

You are not allowed to reply in this post.
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...