Custom Form Formula

  • Thread starter Thread starter Bucklebery
  • Start date Start date
B

Bucklebery

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
 
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/com...spx?dg=microsoft.public.outlook.program_forms
 
Back
Top