Why lost decimal places in euro fields?

  • Thread starter Thread starter Harmannus
  • Start date Start date
H

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
 
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?
Click to expand...

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.
 
Hallo John,

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

Regards, Harmannus
 
Back
Top