VBSCRIPT Validate

[Guest]

Hi, for my custom form I have the following code:

Sub Item_Write()
If Item.UserProperties("Development Completed") <> #1/1/4501# and _
Item.UserProperties("Version Changed") = "" Then
msgbox ("error")
End If
End Sub

Currently when this clasue is trapped a message box appears showing an error
so I know the syntax is correct. At this point how do I
a) Prevent the form from being closed
b) Navigate the user to the field that is causing the error.

Thank-you/

 

[Sue Mosher [MVP-Outlook]]

a) Rewrite the procedure as a Function (which the Script | Event Handler command in the form code window would have done for you) and add an Item_write = False statement where you want the item not to be saved.

b) Use the SetFocus method on the desired control. See http://www.outlookcode.com/d/propsyntax.htm#unbound if you need a primer on control syntax. s

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[Guest]

Thanks - can I also programmatically change to the tab with the field in
question ?

 

[Sue Mosher [MVP-Outlook]]

Yes, using the Inspector.SetCurrentFormPage method. (You do know about the object browser, right? F2 in VBA)

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[Guest]

I do now thanks.

Yes, using the Inspector.SetCurrentFormPage method. (You do know about the object browser, right? F2 in VBA)

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers