Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 01-05-2012, 06:24 AM
skarden skarden is offline Can I embed a Ref field in an If field in Word 2003? Windows XP Can I embed a Ref field in an If field in Word 2003? Office 2003
Novice
Can I embed a Ref field in an If field in Word 2003?
 
Join Date: Dec 2011
Location: Orlando, FL
Posts: 27
skarden is on a distinguished road
Smile Can I embed a Ref field in an If field in Word 2003?

I am using Word 2003. I have a template with 2 text controls: Text1 and Text2. I have calculate on exit set to True on both.



I then created the follwing (BTW, below is typed, I used the "real" Word fields in my document):

{IF {REF Text1 \* Upper} = "M" "he" "she"}.

No matter what I do, it always comes out false, (she in this example).

I tried making Text1 to auto-uppercase, I tried taking the \* Upper out of the REF filed, I tried not using the quotes, etc.

When I tried it in the negative, i.e.

{IF {REF Text1} <> "" he she}

it always returns the true (he in this example) even if I go into Text1 properties and then re-lock the form (which wipes out whatever was in there before, so I know the field is empty).

Can an IF fieled evaluate a REF field? If so, how?

Thanks,

Last edited by skarden; 01-05-2012 at 03:57 PM.
Reply With Quote
 

Tags
embed, if fields, ref fields

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Have Text Entered in Content Control / PreDefined Field Populate Field in Footer bzowk Word 1 04-14-2016 11:50 AM
Creating new field in pivot table based off existing field laceymarie1987 Excel 0 06-26-2014 12:13 PM
Can I embed a Ref field in an If field in Word 2003? How to ignore a mail merge field if the field is blank redzan Mail Merge 1 05-16-2013 08:34 AM
Field not showing in Pivot Table Field List kmcovington Excel 0 10-26-2012 10:14 AM
Formula to subtract one month from due date field in reminder field ghumdinger Outlook 1 10-01-2011 12:09 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:56 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