Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-17-2014, 03:08 PM
robicomi robicomi is offline drop down Windows 8 drop down Office 2007
Novice
drop down
 
Join Date: Nov 2014
Location: Berlin
Posts: 2
robicomi is on a distinguished road
Default drop down

Hi, we want to insert some text fields, which are automatically fill out when selecting one word in a drop down box. (We are using word 2007)



The dropdown box we created with the legacyformulars (alternatifly also with the active elements).

For example in the dropdown box (word calls this combobox) we slect "man" and than in a text field should appear "male".

We read that could be possible over the the "if" function. we put something {if ref dropdown1 = "man" " male"}

But does not work. In the internet are not really detailed manuals for this?? We would be really happy is somebody could help us.
Reply With Quote
  #2  
Old 11-17-2014, 11:51 PM
gmayor's Avatar
gmayor gmayor is offline drop down Windows 7 64bit drop down Office 2010 32bit
Expert
 
Join Date: Aug 2014
Posts: 4,137
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

It does work but you have the syntax wrong. It should be

{ If { Ref Dropdown1 } = "man" " male"}

Both sets of brackets { } are placed with CTRL+F9.

The Bookmark name and the result from that bookmark are case sensitive, so ensure that you get the spellings correct.

Check the dropdown field property check box 'calculate on exit' or nothing will happen.

The field construction will not work in the header/footer or any other story range that is not the main document.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #3  
Old 11-18-2014, 02:00 PM
robicomi robicomi is offline drop down Windows 8 drop down Office 2007
Novice
drop down
 
Join Date: Nov 2014
Location: Berlin
Posts: 2
robicomi is on a distinguished road
Default

Hallo GMAJOR; First of all thanks a lot for your support. I tried your advise but it did not work. I inserted a dropdown box, I choiced calculated for exit and than inserted under the box (in the plain document) the if conditions but did not work.

By trieing out now so many versions I reallized that there are three different version to include a dropdown box, the one i used so far (the one over the legacy tools) i do not really like, because I always have to protected the document before is activated.

I prefere the dropdown box which is you can select by the icon dropdown box. However the property window of this dropdown looks different, you can chose a titel and a tag but there is not calculate on exit button.
Reply With Quote
  #4  
Old 11-18-2014, 11:11 PM
gmayor's Avatar
gmayor gmayor is offline drop down Windows 7 64bit drop down Office 2010 32bit
Expert
 
Join Date: Aug 2014
Posts: 4,137
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

The code I posted works with legacy form fields which have the property I referenced. The content control drop box has a different set of benefits but there is no automatic field updating associated with it. To achieve what you want with content controls you will need macros. See http://gregmaxey.com/word_tip_pages/...om_events.html
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
drop down Drop Down List Help ksigcajun Word 3 05-09-2014 05:35 AM
Drop Down Box teza2k06 Word 2 02-09-2014 05:59 PM
Help, auto select drop down by another drop down value? skrallemand Word VBA 3 09-11-2013 11:55 AM
drop down box dockta Word 1 03-25-2013 10:12 PM
Drop Down Form Help jwm1346 Word 3 07-31-2012 07:49 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:20 AM.


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