Share via

Inserting auto text depending on which drop-down entry is selected

Anonymous
2011-04-03T09:12:04+00:00

I have created a form using the Legacy tools. There is a drop-down menu for user's to select their office locations and depending on their selection I want the phone field to automatically update.

This is my first time to use these fancy functions within word....

So I am not up to date with the jargon so I don't really know how to describe it more clearly.

thanks

<br>From:
<br>Location:<br><Sydney>    <<-- drop-down
<br>Phone Number:<02 9999 9999>   <--  auto text entry required?
<br>Number of Pages (Inc. cover):<br>1<br><br><br><br>
Microsoft 365 and Office | Word | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

Answer accepted by question author

Anonymous
2011-04-03T10:10:55+00:00

You can do this with a series of conditional fields e.g. assuming the bookmark name of the dropdown field is Dropdown1 - check its calculate on exit check box property and at the place you want the number to appear create a series of conditional fields with no spaces between them - one for each entry in your dropdown:

{ IF { REF Dropdown1 \*lower } = "sydney" "123 4567"}{ IF { REF Dropdown1 \*lower } = "london" "456 1234"}{ IF { REF Dropdown1 \*lower } = "new york" "999 7777"}

Then as you tab out of the dropdown field, (with the form protected for forms) the appropriate number will show. If you don't use the \*lower switches, you will have to use the exact case as shown in the dropdown entries.

Was this answer helpful?

0 comments No comments

0 additional answers

Sort by: Most helpful