Code

Re: Validation rule which enforces highest number in a field

Mc2102 — Fri, 01 Jul 2011 18:09:37 GMT

@Jimmy

I will give that a try but I am not sure if that will work since I have some additional data in the field.

Re: Validation rule which enforces highest number in a field

Mc2102 — Fri, 01 Jul 2011 18:07:47 GMT

@Hilary

Yes there is additional text in the field. Actually the field contain a subnet address. So the string would look like this: 192.168.10.0\24.

I want to make sure that none of the numbers between the dots is higher then 255.

I was using MAX because I do not really know exactly how to challenge this and this function sounded like it could work.

Re: Validation rule which enforces highest number in a field

Jimmy — Fri, 01 Jul 2011 16:19:10 GMT

Are you saying that you selected "contains" in the middle dropdown box? If so, you should be selecting "is greater than" and then just entering 255 in the third box.

Re: Validation rule which enforces highest number in a field

Hilary Stoupa — Fri, 01 Jul 2011 16:01:15 GMT

Is there other text in the field? Or are you just checking for 255? Is the field repeating (I ask cause you are using Max).

I did a quick test - just used field1 > 255 for the condition, and when the field had a number greater than 255, the validation worked as anticipated (which is why I think I may not be quite understanding your scenario).

Validation rule which enforces highest number in a field

Mc2102 — Fri, 01 Jul 2011 15:52:11 GMT

Hello,

I am trying to build a validation rule for a InfoPath 2010 form which simply does not allow any number higher then 255 in a text field.

This is what I have and what does not work:

Run the rule when this condition is true:
Field1 - contains - max(Field1) > 255

But it does not work. The rule never applies and does not prevent the use from typing in a number higher then 255.

How can I make this happen?

Thank you Mc2102