Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-30-2015, 08:45 AM
AJohn403 AJohn403 is offline Auto Text Drop Down List Windows 7 32bit Auto Text Drop Down List Office 2010 32bit
Novice
Auto Text Drop Down List
 
Join Date: Apr 2015
Posts: 4
AJohn403 is on a distinguished road
Exclamation Auto Text Drop Down List

Hi!


I'm making a form for my office, and ive run into an issue.
Is there a way to make a drop down list of names, that can be clicked, then auto populate an address with autotext or something similar?

The form has fillable form boxes so it will be a protected document
I'm using word 2010 and windows 7
Thank you for any help
Reply With Quote
  #2  
Old 04-30-2015, 10:02 AM
Charles Kenyon Charles Kenyon is offline Auto Text Drop Down List Windows 8 Auto Text Drop Down List Office 2013
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,140
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

Name a bookmark for the field where you will put the key information. Then use IF Fields elsewhere to put in the information that depends on the key. Make sure the key field has the attribute set to calculate on exit.
Reply With Quote
  #3  
Old 04-30-2015, 11:50 AM
AJohn403 AJohn403 is offline Auto Text Drop Down List Windows 7 32bit Auto Text Drop Down List Office 2010 32bit
Novice
Auto Text Drop Down List
 
Join Date: Apr 2015
Posts: 4
AJohn403 is on a distinguished road
Default

Quote:
Originally Posted by Charles Kenyon View Post
Name a bookmark for the field where you will put the key information. Then use IF Fields elsewhere to put in the information that depends on the key. Make sure the key field has the attribute set to calculate on exit.
Could you give an example of the IF statement? I'm struggling to figure it out on my own.
Reply With Quote
  #4  
Old 05-01-2015, 05:00 AM
Charles Kenyon Charles Kenyon is offline Auto Text Drop Down List Windows 8 Auto Text Drop Down List Office 2013
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,140
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

The link I gave has examples. Here is one of them:
{IF { Mergefield Gender } = "Male" "He" "She"}

converted to your use:


{IF { Ref Keyname} = "Jim" "5555 Odana Road"}
{IF { Ref Keyname } = "Mike" "215 South Hamilton Street"}

Those two would be placed in a Word document with no space between them (and no paragraph break). They only contain truetext; that is, they test for the text in the Keyname bookmark and give you something if there is a match. It is possible to nest another IF field as falsetext, but I find that to be cumbersome and there are limits to how deep you can nest IF fields. There are no limits of which I am aware on the number of IF fields you can have in a document.

Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
form control Field - Drop down auto text mrtinfl Word 5 11-19-2014 06:57 AM
Populate Word Drop-down list with Excel column then auto fill form fields with Excel data Faldinio Word VBA 7 10-19-2014 06:03 AM
Auto Text Drop Down List DRop down list within text of If statement sbarron76 Mail Merge 2 05-03-2013 05:00 AM
Auto Text Drop Down List Populating ComboBox or Drop Down list with contents of a text field Billy_McSkintos Word VBA 1 09-13-2011 05:50 AM
Auto Text Drop Down List Form Field - Drop down selection causing auto text chesspupil Word VBA 7 05-09-2010 05:43 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:29 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft