SPList.ValidationFormula property

Gets or sets a formula that is evaluated each time that a list item is added or updated.

Namespace:  Microsoft.SharePoint
Assembly:  Microsoft.SharePoint (in Microsoft.SharePoint.dll)

'Declaration
Public Property ValidationFormula As String
    Get
    Set
'Usage
Dim instance As SPList
Dim value As String

value = instance.ValidationFormula

instance.ValidationFormula = value

public string ValidationFormula { get; set; }

Type: System.String
The formula that will be used to evaluate data in the item. The rules for constructing a formula are similar to those for creating formulas for calculated fields. For more information, see Calculated Field Formulas.

Each time that a list item is added or updated, the validation formula is evaluated. If the formula evaluates to false, or if a calculation error occurs, the update is not permitted and the message in the ValidationMessage property is displayed.

Keep in mind that each field in a list item has a ValidationFormula property of its own. The difference is that the validation formula for a field can refer only to that field, whereas the validation formula for a list item can refer to several or even all fields in the item.

SPList class

SPList members

Microsoft.SharePoint namespace

ValidationMessage

ValidationFormula

EnforceDataValidation