Validation rule in an access form on an unbound text

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
 

Attachments

  • Productivity Test.zip
    266 KB · Views: 41
Top