Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-22-2020, 04:21 PM
lburch lburch is offline Hide table based on dropdown list Windows 10 Hide table based on dropdown list Office 2016
Novice
Hide table based on dropdown list
 
Join Date: Jun 2020
Posts: 1
lburch is on a distinguished road
Default Hide table based on dropdown list

Hi,

I would like to have a dropdown list (currently using "legacy") and then based on that selection show 1 of three tables (i have three options in dropdown list)
Metal
Tile
Metal and Tile

I have tried inserting If statement with no luck. I even tried a test one


{ IF {Dropdown2} = "Metal" "Test" }

But i get
Error! Missing test condition.

I get the feeling i am not constructing IF statement correctly.
Reply With Quote
  #2  
Old 06-23-2020, 04:45 AM
macropod's Avatar
macropod macropod is offline Hide table based on dropdown list Windows 7 64bit Hide table based on dropdown list Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 20,491
macropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant future
Default

You should use:
{IF{REF Dropdown2}= "Metal" "Test"}

Note: Both sets of field brace pairs (i.e. '{ }') for the above example are created in the document itself, via Ctrl-F9 (Cmd-F9 on a Mac or, if you’re using a laptop, you might need to use Ctrl-Fn-F9); you can't simply type them or copy & paste them from this message. The spaces represented in the field constructions are all required.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Hide table based on dropdown list Show/Hide content based on dropdown value AOSMITH Word 5 11-19-2019 07:19 PM
Show/Hide text based on dropdown value AOSMITH Word VBA 2 11-19-2019 02:19 PM
Text based on selection of dropdown list cloud67 Word VBA 2 08-09-2019 06:46 AM
Hide table based on dropdown list Auto populate a text field based on Content Control Dropdown List matthias92701 Word VBA 2 05-02-2019 03:54 PM
Looking to copy select cells in table using dropdown list to paste to new table in another worksheet CaptainRetired Excel Programming 18 01-04-2018 07:22 PM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 03:33 PM.


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