Using templates

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

boanerges - 27 Sep 2006 18:23 GMT

I have a simple MS Word template created in Office 2003 that I have
added drop down menu boxes to certain fields. By making a specific
selection in these dropdown menus can I trigger a specific
autofill/completion of a separate cell in a table? Does it require a
macro or can I just use the Autotext feature? Basically I'm trying to
get something akin to a IF 'A' is selected THEN 'B' in a different cell
or field.

Thanks for any help and if there is another forum that can give advice
I'll take it too.

Tim

Reply to this Message

Cindy M. - 29 Sep 2006 12:40 GMT

Hi Boanerges,

> I have a simple MS Word template created in Office 2003 that I have
> added drop down menu boxes to certain fields. By making a specific
[quoted text clipped - 3 lines]
> get something akin to a IF 'A' is selected THEN 'B' in a different cell
> or field.

If the dropdown field is from the Forms toolbar, then you should be able
to get it to work with the IF field approach you propose. If there are a
lot of variations, it could be difficult to set up and maintain.

The dropdown formfield has/can be assigned a name (double-click it to get
the Options dialog box). The name serves also as a bookmark. And you can
display the contents of a bookmark by using a REF field.

A REF field can be nested in an IF field. So:

{ IF { REF Dropdown1 } = "abc" "something" "" }{ IF { REF Dropdown1 } =
"xyz" "another thing" "" }

would be the easiest way to set this up. (Remember, you have to press
Ctrl+F9 to insert the field bracket pairs { }; Alt+F9 to turn field codes
on/off; F9 to force an update of the field.)

Make sure you activate the "Calculate on exit" checkbox in the Options
dialog box, as well, so that the IF fields update when the user moves
away from the dropdown.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

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