Display decimal Places

[jamesnkk]

I have a currency field Total_Amount in the form,it display at 2 decimal places,
but if i click on the field, it display 4 decimal places.

How do I not show 4 decimal places but only show 2 decimal places, when click on the field. I do not want to modify the table structures.

[Zwoker]

I have a currency field Total_Amount in the form,it display at 2 decimal places,
but if i click on the field, it display 4 decimal places.

How do I not show 4 decimal places but only show 2 decimal places, when click on the field. I do not want to modify the table structures.

You are saying that the text box shows as 2 decimal places until you click on it, then it switches to 4 by itself? Curious.

Have you set an explicit number of decimal places in the Decimal Places property of the text box?

[jamesnkk]

You are saying that the text box shows as 2 decimal places until you click on it, then it switches to 4 by itself? Curious.

Have you set an explicit number of decimal places in the Decimal Places property of the text box?

Yes, exactly, I have also set the textbox property in the Format Tab as Currency
Decimal Places = 2. But when I click on it, it display with 4 decimal places

[jamesnkk]

Hi,
I manage to overcome it by using GotFocus.