4 Replies Latest reply on Aug 20, 2012 7:51 AM by kluetkenhoelter

    Field Validation, doesn't



      Field Validation, doesn't


      I have noticed that field validation on seems to work on commiting a record or forcing the entry of the record.  I have not seen this before although I thought that validation occured when you modified a field or left the field.  Using FMP12, am I am doing something wrong?

      My validations of a date field was to assure that the date was not a Sunday.

      Validation by calcualtion = If(DayOfWeek(Date_field) = 1, 0, 1)      // Sunday=1

      This works, but not on field exit or tabbing to next field.  It works when total record is entered.

      Am I missing an option to validate?