Hi everyone. I'm working in Access 97. I have a text box that is populated when a user clicks a command button. When clicked a calculation is done and the value of the text box is set to the result. This all works fine. I have the text box format set to Fixed and the decimal place property to 2. It works. The number is displayed with two decimal places. However, when I click on the text box, it shows all the decimal places until the focus is shifted elsewhere. Can I format the number of decimal places when I perform the calculation?
Thanks in Advance,
Jason
Thanks in Advance,
Jason