Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-31-2014, 03:31 AM
Anja Anja is offline if statement does not work Windows 8 if statement does not work Office 2013
Novice
if statement does not work
 
Join Date: Oct 2013
Posts: 6
Anja is on a distinguished road
Default if statement does not work

I generated a drop down list (content controls) and if statements depending on drop down list one year ago.

I have a drop down list with A, B, C and D possibilities.
If I choose an "A" in a drop down list, I want that in the text later on "You choose A" is written, if I choose B in a drop down list I want "You choose B" to be written and so on.

I used this formulas:
{ IF { REF Dropdown1 } = "A" "You choose A” “" }
{ IF { REF Dropdown1 } = "B" "You choose B” “" }
{ IF { REF Dropdown1 } = "C" "You choose C” “" }




This funktion always worked until few days ago. I didn`t change anything, it is just not working. I also tried to generate new drop down list called "test" with options "A" and "B", new bookmark called "test" and wrote formula { IF { REF test \h } = "A" "You choose A” “" }. And it is not working at all. What is the problem?


Reply With Quote
  #2  
Old 11-11-2014, 07:47 AM
Anja Anja is offline if statement does not work Windows 8 if statement does not work Office 2013
Novice
if statement does not work
 
Join Date: Oct 2013
Posts: 6
Anja is on a distinguished road
Default

Does anyone know how to solve the problem?
Reply With Quote
  #3  
Old 11-11-2014, 08:16 AM
gmayor's Avatar
gmayor gmayor is offline if statement does not work Windows 7 64bit if statement does not work 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

Are you sure that you meant a content control and not a legacy form field (which would be associated with a bookmark name of Dropdown1)?

I can't see this ever working with a content control without the use of macros.

With a legacy dropdown form field in a document protected for forms it should work if the bookmark name matches and you have the calculate on exit check box checked.
__________________
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
  #4  
Old 11-11-2014, 02:08 PM
macropod's Avatar
macropod macropod is offline if statement does not work Windows 7 64bit if statement does not work Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,343
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by Anja View Post
Does anyone know how to solve the problem?
A little more patience on your part wouldn't go astray. Your first post was at 10:31pm (my time) and your follow-up post was just a few hours later, at 1:47am. Guess what I might have been doing at that time. I'm sure Graham doesn't spend all his time waiting for posts, either.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
How to get the if then else statement to work pamed53 Excel 3 05-01-2014 10:12 AM
Format Switch \* Caps won't work in if..then statement cwright Word 2 03-27-2014 04:19 PM
if statement does not work work of labor vs work of excavator ketanco Project 1 02-11-2014 08:53 AM
if statement does not work Help with IF Statement limpbizkit Excel 4 02-24-2011 09:16 PM
if statement does not work if statement piper7971 PowerPoint 1 08-19-2010 07:10 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:52 PM.


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