CellValidationErrorDescription

This property sets or returns the ErrorDescription for the cell validation.

Syntax

CellValidationErrorDescription (Column as Variant, RowIndex as Long) as String
Parameter Description
Column Zero-based index or name of column
RowIndex Zero-based index of row

Sample Code

Private Sub MyTableField_ValidateCell(pTable as SCBCdrPROJLib.SCBCdrTable, pWorkdoc as SCBCdrPROJLib.SCBCdrWorkdoc, ByVal Row as Long, ByVal Column as Long, pValid as Boolean)
   Select Case Column
      Case 0:
      'check date in column 0
      if CheckDate(pTable.CellText(Column, Row)) = FALSE then
         pValid = FALSE
         pTable. CellValidationErrorDescription(Column, Row) = "Invalid date"
      end if
      Case 2:
      'check order number in column 2
      if CheckOrderNumber(pTable.CellText(Column, Row)) = FALSE then
         pValid = FALSE
         pTable. CellValidationErrorDescription(Column, Row) = "Invalid order number"
      end if
   End Select
End Sub