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

Discussion

Discussion

Canadian Currency field does not format properly in Designer Mode

Forms Forms Layout Designer
Updated February 19
posted on February 13

One thing I noticed this morning is that when a Currency field is specified in Canadian dollars, and that field is the result of a math calculation on other fields (in my case, the sum of Item Subtotal + GST), the field does not format to two decimal places if there is a "0" in the hundredths/cents position:


Changing the field to US Dollars fixes the problem, however I wanted to bring this to your attention just in case there may be other currencies that behave in this same fashion.

1 0
replied on February 17

Hi Marty, can you test focus out of the field and see if the hundredths "0" would be appended?

It is known behavior that when you focus into the currency/number field, the format may not match the field setting. It would be formatted once you focus out of the field:

Focus in:

Focus out:

0 0
replied on February 19

The formatting does appear to work after tabbing to another field.

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

Sign in to reply to this post.

Details
Related Posts
Loading ...