![]() |
#1
|
|||
|
|||
![]()
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. |
#2
|
||||
|
||||
![]()
Hi Skarden
Yes, it works - see attached. FWIW, unless you're using a dropdown formfield, you don't even need the 'REF'.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
![]()
THANKS!! Not sure why Ref field didn't work, but only was going that way to have it instantly update.
|
![]() |
Tags |
embed, if fields, ref fields |
|
![]() |
||||
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 |
![]() |
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 |