I am having problem in Currency format. How can I avoid the user to input the decimal point(.) twice?
For example: 102.102.05
This might bugs the system when performing calculation. I don't want to trap this by using message box but I mean to say is that not allow the user to input the second decimal point when it was press in the keyboard. I am using MS Access97 as my database. I use the field type, Currency in database but it doesn't seems trapping the decimal point when user input. I also use this format:
unitprice.Text = Format(unitprice.Text, "#,###,###.00")
But still doesn't work. Hope to hear any comments from you.
Thank you very much.