At 03:26 2013-11-28, Peter Cushing <[email protected]> wrote:
Gene Wirchenko wrote:
I want to use BeforeRowColChange to do the row-level validation,
and when it fail, put the focus on one of the controls involved in the error.
[snip]
Don't think that will work. You explained a rule that said say
columns A + B = C + D. If you have a validation rule that puts you
on A every time, when you want to change D, you will not be able to
do it. If you just allow full
Yes, I would. A row-level validation rule will not stop focus
from leaving a control (unless it is also a row change and an error
condition). The row-level validation is executed only when there
might be a row change. It will not stop focus changes within the row.
access to the row, and check every time they enter a value then the
errors can be corrected.
Aren't you contradicting yourself when you state "check every
time they enter a value"? If I check every time, then it will throw
an error if I change one of the values. Correcting an error might
involve more than one of the controls. That is why the validation is
row-level; it does not make sense at the individual control level.
My problem is getting the current values of the
controls. Other than that, my code works. Unfortunately, not having
the current values of the controls makes a mockery of validation and
is a show-stopper.
Sincerely,
Gene Wirchenko
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
