IF field code

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Micayla - 06 Nov 2003 01:29 GMT

I am trying to get an IF function to work based on the
data in a dropdown menu:

If (dropdown 17)=refer to page 8 "refer to
paragraph9" "refer to paragraph 11"

I thought that if dropdown 17 does not equal refer to
page 8 then the false text would be entered, but that is
not happening.

What am i doing wrong?
Thanks!

Reply to this Message

Doug Robbins - Word MVP - 06 Nov 2003 07:14 GMT

Hi Micayla

The field construction that you need is

{ IF { REF Dropdown17 } = "refer to page 8" "refer to paragraph9" "refer to
paragraph 11" }

where each pair of {} is inserted by using Ctrl+F9 and Dropdown17 is the
bookmark name assigned to the dropdown formfield.

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

> I am trying to get an IF function to work based on the
> data in a dropdown menu:
[quoted text clipped - 8 lines]
> What am i doing wrong?
> Thanks!

Reply to this Message

Micayla - 10 Nov 2003 01:28 GMT

Thank you Doug and Cindy
I have input the field construction exactly as necessary
so far as i can see, and enabled the calculate on exit. i
cannot find the reason why this will not work for me. is
there anything else i could be missing?
Thanks for your help.

>-----Original Message-----
>Hi Micayla
[quoted text clipped - 27 lines]
>
>.

Reply to this Message

Micayla - 10 Nov 2003 03:56 GMT

actually i have it working now, thanks!!

>-----Original Message-----
>Thank you Doug and Cindy
[quoted text clipped - 46 lines]
>>
>.

Reply to this Message

Cindy M -WordMVP- - 06 Nov 2003 10:46 GMT

Hi Micayla,

Are we talking about a Dropdown form field, from the Forms
toolbar? Unfortunately, more recent versions of Word can't
pick up the settings of either checkbox or dropdown form
fields.

I'm afraid you'll need a macro to test the value of the
dropdown form field and fill in the proper information
(probably in a text form field that is not enabled for user
input).

> I am trying to get an IF function to work based on the
> data in a dropdown menu:
[quoted text clipped - 5 lines]
> page 8 then the false text would be entered, but that is
> not happening.

Cindy Meister

Signature

INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update
Sep 30 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail

:-)

Reply to this Message

Doug Robbins - Word MVP - 06 Nov 2003 13:33 GMT

Hi Cindy,

The field construction

{ IF { REF Dropdown17 } = "refer to page 8" "refer to paragraph9" "refer to
paragraph 11" }

works in Word 2003 where Dropdown17 is the name of the bookmark assigned to
the dropdown field and its Calculate on exit box is checked

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

> Hi Micayla,
>
[quoted text clipped - 27 lines]
> follow question or reply in the newsgroup and not by e-mail
> :-)

Reply to this Message

Cindy M -WordMVP- - 07 Nov 2003 17:52 GMT

Hi Doug,

You're right. And I just went and checked 97, 2000 and 2002 and it's the same
there. But I could swear, "once upon a time", this didn't work.

Thanks for double-checking!

-- Cindy

> The field construction
>
[quoted text clipped - 3 lines]
> works in Word 2003 where Dropdown17 is the name of the bookmark assigned to
> the dropdown field and its Calculate on exit box is checked

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail :-)

Reply to this Message