Calc: If Validation fails...

[MariaAux]

I have got a global field for the user to select from a drop down menu. I can't deny access to them because the field needs to be accessed in order to use the drop down menu. If the user clicks twice within the field, they can actually enter a value that is not on the value list. I have validation setup so that if this occurs, the user receives a message. I don't like the message.

Isn't there a calculation that I can run as part of a script trigger that basically says;

If field is modified to a a value that is not part of the value list, revert field?

Thanks so much for your help in advance and have a fab day.

[doughemi]

In the Fields tab of Manage Database, press the Options button, then click the Validation tab. You will see a Member of Value List checkbox.

[MariaAux]

Yes, I have already set the field to be validated. However, I dont want the user having to be prompted with the default or custom validation popup and being asked to press 'Revert field. Isn't there a script I can use that will suppress the validation failed popup and revert the field to what it was without user interaction?

Thanks again.

[LaRetta]

Hi Maria,

Field-level validation is important for ultimate protection but you can add script trigger using OnObjectValidate to act on the failure first. Read up on it in Help. :-)

[MariaAux]

Yeh that was what I was looking for. A quick script trigger to simply 'Undo0 upon validation fail.

thanks so much