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,

Hi Skarden

Yes, it works - see attached. FWIW, unless you're using a dropdown formfield, you don't even need the 'REF'.

Attached Files

MF.doc (29.5 KB, 17 views)

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

THANKS!! Not sure why Ref field didn't work, but only was going that way to have it instantly update.