Share via

UserProperty.ValidationFormula Property

  • Article
Outlook Developer Reference

Returns or sets a String indicating the validation formula for the user property. Read/write.

Syntax

expression.ValidationFormula

expression   A variable that represents a UserProperty object.

Example

The following Visual Basic for Applications (VBA) example demonstrates the use of ValidationText and ValidationFormula properties.

Visual Basic for Applications 
  Sub TestValidation()
    Dim tki As Outlook.TaskItem
    Dim uprs As Outlook.UserProperties
    Dim upr As Outlook.UserProperty
    
    Set tki = Application.CreateItem(olTaskItem)
    tki.Subject = "Work hours"
    tki.TotalWork = 3000
    Set uprs = tki.UserProperties
    Set upr = uprs.Add("TotalWork", olFormula)
    upr.Formula = "[Total Work]"
    upr.ValidationFormula = ">= 2400"
    upr.ValidationText = """The WorkHours (Total Work) should be equal or greater than 5 days """
    tki.Save
    tki.Display
    MsgBox "The Work Hours are: " & upr.Value
End Sub

Remarks

The validation formula is used by Outlook to validate the Value property when an item is saved.

See Also