Creating a validation formula in Outlook 2003

[Gladys]

I am a beginner in programming and I need help with the validation feature.
I've got two questions:

1) I am working on a custom request form which requires users to enter a
date into a text box. Instead of using the option "a value is required for
this field", which does not identify which field needs to be updated, I will
like a message to say "please enter the date". What formula should i input
into the validation formula?

2) I have a combo box with a drop down list of currencies (i.e. USD, EUR,
GBP, other type of currency). I have created a textbox right beside this
combo box, so in the event if any user chooses "other type of currency", they
will have to enter the currency type in the text box. But sometimes, people
may forget to enter this info. So how do I create a validation with a message
that says "please enter the type of currency used in this contract?"

Thanks!
Gladys

 

[Sue Mosher [MVP-Outlook]]

1) A validation formula must return True if the data is "good" and False if it is not. The right expression depends on what type of field the control is bound to. In your scenario, it could be a date/time field or a text field.

2) Again, True if "good," False if not. So what's good? Either a choice other than "Other Currency" or a proper entry in the text box, thus:

([Currency] <> "Other Currency") Or ([Other Currency] = "")

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

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