thedeadzeds
New member
- Joined
- Oct 25, 2011
- Messages
- 37
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 2016
Hi All,
Is there a way to add a validation rule in an access form on an unbound text box. This box is currently doing a calculation of others. If the figure is not between 0 And 0.3125 then I do not want the user to be able to move on. For some reason if I enter ‘Between 0 And 0.3125’ in the validation rule it doesn’t seem to do anything. I can only assume its because its an unbound text box. Data attached please see Frm_Input and text box total standard hours.
Many thanks
Craig
Is there a way to add a validation rule in an access form on an unbound text box. This box is currently doing a calculation of others. If the figure is not between 0 And 0.3125 then I do not want the user to be able to move on. For some reason if I enter ‘Between 0 And 0.3125’ in the validation rule it doesn’t seem to do anything. I can only assume its because its an unbound text box. Data attached please see Frm_Input and text box total standard hours.
Many thanks
Craig