Validation Question...

[former_member469694]

I have a requirement that the field NAME has the valid values only "-", "/", " ' ". All other puncations/ special chrs will be in error.

How to code this expression?. Anyone can help me with this?

[Former Member · Accepted solution]

Hello Mike,

You can use the "FIND" property on NAME field.

Try in this way

(FIND( NAME , "-") OR FIND(NAME,"/") OR FIND(NAME," ' "))>0

U can try this validation with logic functions.If any among these characters are there it will TRUE esle False in all other cases.

Just try.If problem persists we will try other ways.

Hope this may help you.

Rgds

Ankit