ValidateValue Event

See Also    Examples    Applies To

Occurs if a value is to be verified.

Event ValidateValue(intCol As Integer, fOk As Boolean)

atb_ValidateValue(intCol, fOk)

intCol

Returns the column of the value that is to be verified (read only)

fOk

This parameter is initially True. Set it to False, if the value is illegal.

To verify a value, use atb.Columns(intCol).Value, because the event may be called for a column other than the current one.

Example

Private Sub atb1_ValidateValue(ByVal intCol As Integer, fOk As Boolean)

    If intCol = 3 Then

        fOk = (atb1.Value(intCol) < 100)

    End If

End Sub