Using templates

B

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
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
 
C

Cindy M.

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
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.
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 :)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top