IF field code

[Micayla]

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!

 

[Doug Robbins - Word MVP]

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

 

[Cindy M -WordMVP-]

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:

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.

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

 

[Doug Robbins - Word MVP]

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

 

[Cindy M -WordMVP-]

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

{ 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

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

 

[Micayla]

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.

 

[Micayla]

actually i have it working now, thanks!!

-----Original Message-----
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.