Restrict Field Data

[Totes]

How do you stop users from entering restricted data into a field. I am more interested in restricting symbols etc "#,%,@".

I found a single post last night but cant seem to bring it up again and I threw away the notes I had started working on a solution.

I think the post I saw was about validation by calc.

Jim

[Totes]

Thanks Laretta,

That was the exact calc I had located.

I have put it in place...I have a question.

Before this works it appears that the user has to click outside the field? If I tab it lets it go, did I do something wrong?

This method is really harsh with the revert box, is there a way to script something with a script trigger and a popup message just telling them to remove the symbol? I tried using the calc with a script & trigger but the Message Box will pop up no matter what I enter in the field.

[comment]

It depends on how strict you want to be: you could trigger a script OnObjectKeystroke and have it beep and return False on objectionable characters.

[Totes]

LaRetta,

I tried the onobjectexit trigger and I think that may be what I need.

Time will tell if they will remove the offending characters or if they will just keep entering data.

Thanks again,

Jim

[Totes]

I missed Comments post somehow...but that may be the ticket.

Thanks to both,

Jim