OUTLOOK 2003 - VALIDATION FORMULA

[Guest]

Greetings,

I have a form and a field on the form the user must enter a number between
0000 and 9999. For the properites of the field under the validation tab, I
have checked the A Value is required for this field and Validate this field
before closing the form. In the validation formula I have [SSN Last Four] > 0
& [SSN Last Four] <9999 and I put a message if the validation fails. When the
form is opened, I leave the field blank and send the form but nothing
happens. Am I missing something or when does the field display. Basically,
how do I activate the formula.

Thanks !

 

[Sue Mosher [MVP-Outlook]]

& is the string concatenation operation. AND is the logical operator that
your formula should be using.


--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

Greetings,

I have a form and a field on the form the user must enter a number between
0000 and 9999. For the properites of the field under the validation tab, I
have checked the A Value is required for this field and Validate this
field
before closing the form. In the validation formula I have [SSN Last Four]

0

& [SSN Last Four] <9999 and I put a message if the validation fails. When
the
form is opened, I leave the field blank and send the form but nothing
happens. Am I missing something or when does the field display. Basically,
how do I activate the formula.

Thanks !