Outlook Form Validation Formula

[Robin]

I want to enter a formula in the validation in an outlook
form. Could someone tell me how to do it? For example, I
want to limit the field to <=60%. I also have a list of
several blanks for the recipient to complete. Does anyone
know if I can add a cell and add the blanks for a total?

Anyone know a good resource for creating Outlook forms?

 

[Hollis D. Paul]

Anyone know a good resource for creating Outlook forms?

The primary resource of all things Outlook is www.slipstick.com. Look
in the library for a good book. Search on formula to see how to create
formulas.

Hollis D. Paul [MVP - Outlook]
(e-mail address removed)
Using Virtual Access 4.52 build 277 (32-bit), Windows 2000 build 2195
http://search.support.microsoft.com/kb/c.asp?FR=0&SD=TECH&LN=EN-US

Mukilteo, WA USA

 

[Sue Mosher [MVP]]

A validation formula simply needs to return a True or False value -- True if you condition is met, False if not. So your formula for the MyProp might be:

[MyProp] <= 60%

(I haven't written any formulas for percentage fields, so I don't know whether it wants the integer or decimal -- experiment!)

You can use a formula field to calculate the sum of several properties: [MyProp1] + [MyProp2] . Note that a formula field can return any value, unlike a validation formula, which must always be True or False.
--
Sue Mosher, Outlook MVP
Outlook and Exchange solutions at http://www.slipstick.com
Author of
Microsoft Outlook Programming: Jumpstart
for Administrators, Power Users, and Developers