June 8, 201015 yr 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?
June 8, 201015 yr 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
Create an account or sign in to comment