Not able to use search operators in a numeric only field

I am having issues with users putting characters in a field that needs to be numeric only. To solve this problem set the filed to the following..

While this solved my data entry problem it caused a new one wile performing searches. With this setting you are not allowed to enter # or * both can be very handy during a search. I realize I can allow user override but that also works during data entry not just searching. I was also thinking about doing a validate by calculation and doing something like this

IsEmpty ( Filter ( 1234567890*#; Self) ) but this as is dose not work at all.

if you set the field to be auto enter calculation = Filter ( the field ; "0123456789" ) it will prevent users from entering anything but numbers. They wont get any feedback that what they are keying in is not what is getting saved to the database however.

If you use this method dont forget to uncheck the do not replace flag.

user19752 Thank you for the quick responses and a way to make it work. I am still wondering though is this the correct way to do it? It still allows a user to enter * or # both unlikely in this case but in other situation I might not be so lucky. It would be nice to have the validation not effect searching.

Hmm, now I tested it on FM16 and FM15, both showed error on using search operator in validated as numeric only field!! This is nonsense, should be reported as bug.

It looks script works as expected, on browse mode it is denied when validation is always, and on find mode it is allowed.

But there is another issue that script can't "Enter browse mode" if search operator is entered by user in such field in find mode. It looks the step trying to "commit record" instead of "delete record" although the step doesn't perform find. (it is not real record, rather sayed request. and "commit request" can't be done when perform find).

After messing with this for the past couple days I think/hope I have come up with the final adjustment to make this work for me. The change you suggested worked but I needed to add a decimal point as well.