Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-27-2014, 11:36 AM
cwright cwright is offline Format Switch \* Caps won't work in if..then statement Windows 7 32bit Format Switch \* Caps won't work in if..then statement Office 2013
Novice
Format Switch \* Caps won't work in if..then statement
 
Join Date: Mar 2014
Posts: 2
cwright is on a distinguished road
Question Format Switch \* Caps won't work in if..then statement

I have a Word merge document where I am trying to get a certain word merge field to appear with Proper case (first letter of each word is capitalized). If I insert the Mergefield and apply the \* Caps switch thie field appears exactly as I want it to. However if I use the merge field in an if..then..else statement with the same switch, the switch seems to be completely ignored. Here is the exact statement I am using:
{ IF { MERGEFIELD Fund_description_1 } = "Annual Giving" "Christian Union Ministry" "{ MERGEFIELD Fund_description_1 \* Caps }" }

I'm using Word 2013. Why won't Word format my field correctly inside this if..the..else statement?
Reply With Quote
  #2  
Old 03-27-2014, 03:52 PM
macropod's Avatar
macropod macropod is offline Format Switch \* Caps won't work in if..then statement Windows 7 32bit Format Switch \* Caps won't work in if..then statement Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
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

Try:
{ IF { MERGEFIELD Fund_description_1 } = "Annual Giving" "Christian Union Ministry" "{ MERGEFIELD Fund_description_1 }" \* Caps }
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 03-27-2014, 04:19 PM
cwright cwright is offline Format Switch \* Caps won't work in if..then statement Windows 7 32bit Format Switch \* Caps won't work in if..then statement Office 2013
Novice
Format Switch \* Caps won't work in if..then statement
 
Join Date: Mar 2014
Posts: 2
cwright is on a distinguished road
Default

Brilliant. That worked. Thank you so much.
Reply With Quote
Reply

Tags
if..then..else, merge, switch



Similar Threads
Thread Thread Starter Forum Replies Last Post
Using conditional formatining to change to all caps Shades Excel 3 05-05-2014 06:05 AM
Format Switch \* Caps won't work in if..then statement Date format switch with If statement sbarron76 Mail Merge 3 05-03-2013 06:23 AM
Format Switch \* Caps won't work in if..then statement Mail merge will not format date field generated by Excel IF statement borntorun75 Mail Merge 3 12-16-2011 06:28 AM
Caps changing after doc is saved???? powerdrum Word 0 11-03-2011 07:36 AM
Multiple drop caps Ziggy-R Publisher 0 10-26-2010 06:23 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:48 PM.


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