Restrict Data 1

[mrkshpntf]

I am trying to restrict users from entering data above and below certain values.

On my form, I have a text box where users need to enter a number which cannot be higher than 2999 and lower than 0001. The value entered here needs to be stored a text datatype.

Where do I add this restriction and how?

 

[PHV]

You may use the ValidationRule property:
Like '####' AND Between '0001' And '2999'

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[mrkshpntf]

Thanks PHV,

It worked!

mrkshpntf.