Using IF to give the value of a bookmark

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Art - 07 Jan 2006 04:34 GMT

How do you use the IF field code to display the value of a bookmark and
blank if the value of the bookmarked field is 1.

I was using the code { IF { RemainMonthPayment} =1, " ", {LastPayment}}
but all I get is an error.

Please help. Thanks.

Art

Reply to this Message

Graham Mayor - 07 Jan 2006 08:27 GMT

Is this a mail merge? Are these merge fields? If they are then
{IF {Mergefield RemainMonthPayment} <> 1 "{Mergefield Last Payment}"}
If they are both bookmarks eg from a form then
{IF {RemainMonthPayment} <> 1 "{Last Payment}"}
will do the trick.
In your example, you don't need the commas and you do need a space after the
=
In a form you will need to set the properties of the relevant fields to
calculate on exit.

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> How do you use the IF field code to display the value of a bookmark
> and blank if the value of the bookmarked field is 1.
[quoted text clipped - 5 lines]
>
> Art

Reply to this Message

Art - 07 Jan 2006 08:53 GMT

Thank you for the reply.

By the way, the form does not use merge fields. I tried using the
second code you mentioned in my Word document

{IF {RemainMonthPayment} <> 1 "{Last Payment}"}

but when I update the field it gives the result {Last Payment}

Both RemainMonthPayment (integer) and Last Payment (date) are bookmarks
from the form.

Need your help on this one.

Reply to this Message

Graham Mayor - 08 Jan 2006 08:11 GMT

You must insert all the field boundaries {} with CTRL+F9 and toggle the
display ALT+F9 to show results as opposed to construction.

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> Thank you for the reply.
>
[quoted text clipped - 9 lines]
>
> Need your help on this one.

Reply to this Message