Display of Currency in form

  • Thread starter Thread starter Rob
  • Start date Start date
R

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
 
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
Click to expand...
--------------------
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,
 
Back
Top