Validate input in a field

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rock* - 19 Jan 2006 23:01 GMT

How can I validate a value in a field against a list of 40 possible options.
Thank you.

Signature

Diana

Reply to this Message

suresh Reddy - 20 Jan 2006 12:34 GMT

Do the Following Steps:
1.Drag Text box and Right click on the text box and GO to text box Properties.
2.Click on Validation button and click on add.
3.Select Field name in first drop down and Equal to in second dropdown.
Moreover, select Number “1” in last dropdown.
4.Repeat same procedure and select Number as 2,3,4,5.
5.Then Go to first dropdowns and change them from Field name to Expressions.
6.Then copy the Expression in notepad and insert “OR” in between them and
copy the whole Expression in the first Expression box and delete others.

Expression is shown as below.

. = 1 or . = 2 or . = 3 or . = 4 or . = 5 or . = 15 or . = 6 or . = 7 or . =
8 or . = 9 or. = 10 or. = 11 or . = 12 or . = 13 or . = 14

You can add up to 40 or more in the similar manner. (By using Expression)

Signature

suresh Reddy
www.autonomysystems.com.

Reply to this Message

Rock* - 20 Jan 2006 18:06 GMT

Hi Suresh

I would like to thank you for your help. I tried reading books and looking
up help online with no result (since it seemed I had to know java script).

Thank you again for the nice summary and help.

Signature

Diana

> Do the Following Steps:
> 1.Drag Text box and Right click on the text box and GO to text box Properties.
[quoted text clipped - 13 lines]
>
> You can add up to 40 or more in the similar manner. (By using Expression)

Reply to this Message