Display of Currency in form

[Rob]

I have created a form and set the format of the fields to
currency with a 0 decimal places.

When I go into form view I see the value as set e.g. $1,234
When I click in the field the view changes to $1,234.8366

What properties do I set so the display stays at $1,234

Any helps would be appreciated.

Rob

 

[Eric Cárdenas [MSFT]]

I have created a form and set the format of the fields to
currency with a 0 decimal places.

When I go into form view I see the value as set e.g. $1,234
When I click in the field the view changes to $1,234.8366

What properties do I set so the display stays at $1,234

Any helps would be appreciated.

Rob

--------------------
The format property only works for displaying the field but not for typing
into the field. To set the typing property, you typically would define a
Input mask. The only problem is that input masks do not work with currency
fields.

You can specify a validation rule that disallows decimal points but other
than that there's little you can do to control the format when the cursor
is on the field.

Hope this helps,