Reviewed November 2010

This will be set to one if the cell indicated by xtr'xrow and xtr'xcol needs validation. Previously you had to rely on exitcode -48 to identify when validation was needed, but this is not adequate when the event which terminates an editable cell operation is a click on another control that generates its own exitcode. In that case, the exitcode returned to the application will be that of the clicked-on control, and the xtr'xvalidate flag will be handy to indicate that the cell identified by xtr'xrow and xtr'xcol needs to be validated.

In some cases, the cell which needs to be validated is not the one that last had the focus, i.e. the one referenced by xtr'xrow / xtr'xcol, but the one which gets the focus, i.e. xtr'targetrow / xtr'targetcol. (This is often the case with checkboxes, which exit for validation only when checked, and is always the case with read-only editable cells, which exit for validation just before they get the focus. In these cases, xtr'xvalidate will be set to two. If xtr'xvalidate is set to three, it means that both the xtr'xrow / xtr'xcol and xtr'targetrow / xtr'targetcol cells need validation. (This would occur when clicking out of a cell that requires post-validation and into a cell that requires pre-validation or validation-on-click.)

See xtr'target... for some detailed examples of validation scenarios.