Prohibiting certain characters

[ejpvi]

I have a field in my database where I was told is being used improperly by certain users.

They need it to match a certain syntax. They want to see if I can prohibit certain characters from being entered.

I am familiar with setting up value list validation... but that is for the entire field.... if I just wanted to block "/","L","W","H" from being used anywhere in the field, is that possible?

[Kris M]

yes its pretty easy using using the Filter() function..

[Raybaudi]

I am familiar with setting up value list validation...

If you want to use the validation option for that field, you can use:

IsEmpty ( Filter ( Self ; "/LWH" ) )

But... you have 10, so why not use an OnOjectKeystroke trigger and the function Code ( ) to block those chars ?

The script to fire is really simple:

If [ ValueCount ( FilterValues ( Code ( Get ( TriggerKeystroke ) ) ; "47¶72¶76¶87" ) ) ]

Exit Script [ Result: 0 ]

End If