Validate input in a field

R

Rock*

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

suresh Reddy

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)
 
R

Rock*

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top