Validation rule in a calculated text box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to put a validation rule in a calculated text box in a form. I
can put one in a regular text box but it does not seem to work in a
calculated text box.

Thx
 
I would imagine that a calculated field does not "fire" the AfterUpdate
event, and therefore no Validation either. The calculated value is derived
"programatically", as opposed to manual entry.
If you are trying to make a decision as to the calculated value, trigger
your code via the entered values that go into that calculation.
For example [Price] * [Qty] = [LineTotal]
LineTotal is calculated...
Use the AfterUpdate of Price or Qty to make your decision as to the Line
Total value
ex. If LineTotal > SomeValue Then... etc etc
ElseIf LineTotal = SomeOtherValue Then... etc etc
hth
Al Camp
 
Back
Top