Hi Experts,
I have a table with several fields that need to be limited with how many places can fall to the right of the decimal. For instance, one field can have four (3.8969) and one field can have two (2.34) while some are whole numbers. I need to limit data entry so the user cannot enter more than the specified places past the decimal. I have specified this in the table (I have the properties set to Double with 2 places in the decimal section) and even when I put this same specification on the properties of the form, I can enter as many numerals as I want past the decimal and it records to the table just like I put it. Help??? Thanks for any help you can give :-)
Laura
Start Free Trial
