Why lost decimal places in euro fields?

[Harmannus]

Hallo,

I have a form with a field for input of salary. Format: euro. Decimal
places: 2.

When i input the salary no problem. But when i click in the field (to
correct the salary) it shows the salary with 10 decimals. How can i prevent
this so it only shows 2 decimals?

Regards,
Harmannus

 

[John Vinson]

Hallo,

I have a form with a field for input of salary. Format: euro. Decimal
places: 2.

When i input the salary no problem. But when i click in the field (to
correct the salary) it shows the salary with 10 decimals. How can i prevent
this so it only shows 2 decimals?

Use a datatype of Currency rather than Number... Double; and set the
Format property of the textbox on the form to Currency, and the Input
Mask to 999990.00.

 

[Harmannus]

Hallo John,

Thanx, thats it! Changed it from number to currency and gone are the
decimals ;-)

Regards, Harmannus