Application.CheckField method (Project)
True if the selected tasks or resources meet the specified criteria.
Syntax
expression. CheckField (_Field_, _Value_, _Test_, _Op_, _Field2_, _Value2_, _Test2_)
expression A variable that represents an Application object.
Parameters
| Name | Required/Optional | Data type | Description |
|---|---|---|---|
| Field | Required | String | The name of the field to search. |
| Value | Required | String | The value to compare with the value of the field specified with Field. |
| Test | Optional | String | The type of comparison made between Field and Value. The default value is "equals". Can be one of the following comparison strings. |
| Op | Optional | String | How the criteria established with Field, Test, and Value relate to the second criteria. The Op argument can be set to "And" or "Or". |
| Field2 | Optional | String | The name of a second field to search. |
| Value2 | Optional | String | The value to compare with the value of the field specified with Field2. |
| Test2 | Optional | String | The type of comparison made between Field2 and Value2. Can be one of the same comparison strings as Test. |
Comparison strings
| Comparison string | Description |
|---|---|
| "equals" | The value of Field equals Value. |
| "does not equal" | The value of Field does not equal Value. |
| "is greater than" | The value of Field is greater than Value. |
| "is greater than or equal to" | The value of Field is greater than or equal to Value. |
| "is less than" | The value of Field is less than Value. |
| "is less than or equal to" | The value of Field is less than or equal to Value. |
| "is within" | The value of Field is within Value. |
| "is not within" | The value of Field is not within Value. |
| "contains" | Field contains Value. |
| "does not contain" | Field does not contain Value. |
| "contains exactly" | Field exactly contains Value. |
Return value
Variant
Example
The following example determines whether value of Duration is equal to 1 and displays an appropriate message.
Sub Check_Field()
Dim T As Task
Dim Result As Boolean
Set T = ActiveProject.Tasks(3)
Result = CheckField("Duration", "1", "equals")
If Result Then
Result = MsgBox(T.GetField(pjTaskName) + " task Duration is equal to value specified.", vbOKOnly, "CheckField Method")
Else
Result = MsgBox(T.GetField(pjTaskName) + " task Duration is not equal to value specified.", vbOKOnly, "CheckField Method")
End If
End Sub
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.