Forms valadation rule for calculated fields?

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

Guest

For an aircraft loading form I have a field that calculates gross weight as
items are added. I have specified a maximum value for the calculated field
but the valadation rule is not enforced.
 
Robert said:
For an aircraft loading form I have a field that calculates gross weight as
items are added. I have specified a maximum value for the calculated field
but the valadation rule is not enforced.
Click to expand...

Validation rules (on a field or control) are only enforced when data is manually
entered into the field/control. It cannot enforce calculations or values that
are inserted programmatically. Use a different event (Form BeforeUpdate
perhaps) to perform the calculation separately and Cancel the update if it
violates your rule.
 
Back
Top