Trouble with large amounts

Trouble with large amounts

I have several currency fields (CAN) defined as 20 max with 2 decimals. When I enter 1000000.01 it saves fine. When I add one more digit  100000000.01 I get a message in the lower left corner of my form that says View error details. Clicking on this message does nothing. I am using Firefox.

This is a stateless form used to enter some data in a master form. If I enter 1000000000.00 in the master form and then view it in the stateless form it displays as 1.0E+9. Both forms have the field defined as currency CAN 20 max with 2 decimals. At one time the field was defined as max 10. I have changed it but it still seems to have a limit of 10 char.

Herb Wexler MBA
www.PreventingMediocrity.com
Norwalk, CT 06854