Field_OnValidate event

This event occurs when a when user attempts to set a new value for a List or Boolean field on the form.

Syntax

Field_OnValidate FieldName , FieldValue )

Arguments

FieldName: The name of the field to validate.

FieldValue: The value of the field to validate.

Remarks

You can use this event to perform tasks such validating user input for a form field. If the return value is empty string then validation is assumed to have been successful.

Example


Function Field_OnValidate(FieldName, FieldValue)
  Field_OnValidate = ""
  'Write custom validation to check that the user is attempting to enter a value for ‘the Amount field that is less than 100.
  If (FieldName = “Amount”) Then
    If (CInt(FieldValue) > 100) Then
      Field_OnValidate = “Amount cannot be greater than 100.”
    End If
  End If
End Function