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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum If function in textbox 0
Form records 6
Access stripping decimal places in query 1
Validation 1
Decimal places in forms 2
Calculation difference after decresing decimal points 1
Data Entry Form with Previous Year's Information 16
A2007 Losing decimal places 1

Back
Top