Force a Custom Task field entry

[K M]

I think I may be making a problem more complex by simply not knowing an
easy way to solve it.

I've developed a custom task request form. It works just fine. However,
I want to force users to have to put how many hours they spent on a task
if they mark the task completed. In other words, if the
percentcomplete=100 and totalwork=0 hours, then I want a message to be
displayed asking them to input the totalwork.

I started on field validation, but couldn't figure it out, so I turned
to VBScript. However, I don't know which event occurs when a user marks
a task complete. I've tried both Item_PropertyChange and Item_Send, but
neither work.

So my question is will Validation work for me, and if not, what will?

Thanks!

My code is below:

Sub Item_PropertyChange(ByVal Name)

if (Item.PercentComplete=100 and Item.TotalWork=0) Then
msgbox "Please enter the total hours spent on this task."
End if

End Sub

 

[Sue Mosher [MVP-Outlook]]

If you want to use the PropertyChange event, see http://www.outlookcode.com/d/propsyntax.htm for how to set it up to determine which property changed.

You can also use a validation formula on either of the form controls involved:

([Total Work] <> 0) OR ([Complete] = False)

 

[K M]

Thanks Sue!

Validation is definitely the way to go for this one. I used your
suggestion and it worked perfectly.

K M