Validating by Calculation

[Len in Winnipeg]

I have set a field to validate by calculation and it does not validate as soon as I tab out, but waits until I create a new record. Is ther a way to set it to validate as soo as you tab out of the field?

[The_General]

I'm having a similar problem. I enter a number that the calculation should not accept. I exit the field. The when I attempt to enter any number it will not accept anything. It should check for vaildation when I enter the number and attempt to exit the field, right?

[LiveOak]

There is a setting to validate only if the field value has been changed. If you are selecting and tabbing out of a field you have not changed, you won't get validation unless this box has been unchecked.

What version of FM are you using?

-bd

[The_General]

I tried that. It seems to accept any numeric value that I enter. Once I enter an invalid value, tab out, and then try to enter any other number it then rejects any number I put in the field.

For the Boolean in "Validated by calculation" can I use the following calculation for the numeric field "current_search_results_page"?

current_search_results_page ? MASTER INVENTORY 2::found_pages