By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,505 Members | 1,549 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,505 IT Pros & Developers. It's quick & easy.

Display decimal Places

100+
P: 134
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.
Mar 12 '08 #1
Share this Question
Share on Google+
3 Replies


Zwoker
P: 66
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?
Mar 12 '08 #2

100+
P: 134
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
Mar 12 '08 #3

100+
P: 134
Hi,
I manage to overcome it by using GotFocus.
Mar 12 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.