Hi,
Not sure how to handle this. I have an input form with Product Number and Quantity. The underlying table is tbl_Orders. Now, the only field that can be changed is QUANTITY. It's a Long Int.
Now, I have a validation in the text field for Quantity that it must be >= 0. However, I'd like to NOT allow any fractions or decimals...ideally by having a validation (if possible). Right now, ACCESS rounds any decimals entered by the user. What is the best way to do this....AND HOW? Should this be done in the form? Please advise if you can.
Thank you in advance.
TN
Not sure how to handle this. I have an input form with Product Number and Quantity. The underlying table is tbl_Orders. Now, the only field that can be changed is QUANTITY. It's a Long Int.
Now, I have a validation in the text field for Quantity that it must be >= 0. However, I'd like to NOT allow any fractions or decimals...ideally by having a validation (if possible). Right now, ACCESS rounds any decimals entered by the user. What is the best way to do this....AND HOW? Should this be done in the form? Please advise if you can.
Thank you in advance.
TN