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)


Public Property ValidationFormula As String
Dim instance As SPList
Dim value As String

value = instance.ValidationFormula

instance.ValidationFormula = value
public string ValidationFormula { get; set; }

Property value

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.


Exception Condition

The string is too long. The maximum length of a validation formula string is 1024.


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.


Formula validation is independent of the type of validation controlled by the EnforceDataValidation property.

See also


SPList class

SPList members

Microsoft.SharePoint namespace