Z
Zack Barresse
Hello everyone,
I have a form that was created by the wizard (not very Access-savvy here). I have a textbox that takes a value for a specific item (Conductivity for a water sample). I need some validation on this textbox when the Next Record button is pushed. It should be anywhere from 2 - 15 (as Double). If the user enters the number as a different log (i.e. 200 - 1500) I need it input into the record as 2 - 15. For example, here are some entries and what their value should be in the table/recordset:
Value Entry
215 2.15
10.55 10.55
1167 11.67
1481 14.81
15.27 15.27
Does this make sense? If more info is needed, let me know.
I have a form that was created by the wizard (not very Access-savvy here). I have a textbox that takes a value for a specific item (Conductivity for a water sample). I need some validation on this textbox when the Next Record button is pushed. It should be anywhere from 2 - 15 (as Double). If the user enters the number as a different log (i.e. 200 - 1500) I need it input into the record as 2 - 15. For example, here are some entries and what their value should be in the table/recordset:
Value Entry
215 2.15
10.55 10.55
1167 11.67
1481 14.81
15.27 15.27
Does this make sense? If more info is needed, let me know.