Creating an input mask for a currency field.

[khuiwong]

I would like to know is there a way to create a mask on a form for a currency field? I don't want a user to be able to enter in like 125.145. I just want to make it so that people can only type in 125.14. Or how can I write VB code to give a warning when a user enter in more than two decimal places.

Many thanks.
Dave

 

[ColinEssex]

Have a look at Access help. Its explains what you have to do.

Col

 

[viperstingray]

if you set the field properly in your table and the display on your form then they could enter in 125.145638547893 for all you care, access will round up or down accordingly. in the above case, the field in the form and in the table will show $125.15. This will be done right after they enter in the value into the text box. Do not bother with the error message, it'll be too annoying for the end user...TRUST ME.