I am using Access 2003 and have a form with a number of unbound text boxes formatted to Standard number, 2 decimal places.
The problem is that whenever you enter a number with more than 2 decimals the textbox rounds the second decimal place up or down which I don't want. I just want to drop off any decimals greater than 2.
For instance if I enter 12.225 in a textbox the value displayed is rounded up to 12.23 and I want it to display 12.22 and ignore the third decimal.
I tried an input mask and that works but is not ideal for my purpose.
Thanks in advance