Custom Form Formula

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bucklebery - 13 Jan 2005 02:50 GMT

Hi - I am trying to write a simple formula that says if one of these 3
fields has a check mark
then put a Yes in the a new field

IIf( [SG1Active] = "Yes" Or [SG2Active] = "Yes" Or [SG3Active] = "Yes","Yes
","No")

But it doesn't work It just says "No" whether or not there is a check in
the box!

Any Ideas what's wrong - I am using Outlook 2003.

Many thanks

Ian

Reply to this Message

Sue Mosher [MVP-Outlook] - 13 Jan 2005 03:44 GMT

It doesn't work because the value of the fields is True or False -- a
logical Boolean value -- not "Yes" or "No", which are string values.

If the new field is a text field, try it this way:

IIf( [SG1Active] = True Or [SG2Active] = True Or [SG3Active] =
True,"Yes","No")

FYI, there is a newsgroup specifically for Outlook forms issues "down the
hall" at microsoft.public.outlook.program_forms or, via web interface, at
http://www.microsoft.com/office/community/en-us/default.mspx?dg=microsoft.public
.outlook.program_forms

Signature

Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

> Hi - I am trying to write a simple formula that says if one of these 3
> fields has a check mark
[quoted text clipped - 11 lines]
>
> Ian

Reply to this Message