[Debbie[_3_]]

How would I do an IF statement where IF a check box is null then do
nothing but if yes, then enter a field.

This is what I am trying to do - { IF {MERGEFIELD FT Contract} = TRUE
(or "") then insert {MERGEFIELD "Start"} otherwise enter text "N/
A"} " }

This is the formula I am using but can't get it to work.

{ IF "{MERGEFIELD FT Contract}" = TRUE "{MERGEFIELD Start}" {"N/A"}
" }

I am thinking it is something like this but it does not work.
Any help would be greatly appreciated.
Thanks in advance.

Debbie

[Peter Jamieson]

It kinda depends on where your checkbox data is coming from, and how you
are connecting to that data. The simplest thing is probably to insert
your mergefield

{ MERGEFIELD "FT Contract" }

and see what results you get for each of the two possible values in your
datasource (assuming you don't also have a third "unspecified" value).

If it's Access,...the value that Word receives from a
boolean/Yes/No/True/False field in Access depends primarily on the
method you use to connect to Access - AFAIK they are as follows:
Connection method "Yes" "No"
DDE -1 0
ODBC 1 0
OLE DB True False

I think one of the following nested fields will work, but I've lifted
this from one of my earlier messages without checking, so you will need
to check for yourself.

{ IF { =IF({ MERGEFIELD "FT Contract" },1,0) } = 1 "{ MERGEFIELD Start
}""N/A"}
or
{ =IF({ MERGEFIELD "FT Contract" },1,-1) \#"'{ MERGEFIELD Start }';'N/A'" }

Every pair of {} has to be a pair of the special field code braces that
you can enter using ctrl-F9)

Peter Jamieson

http://tips.pjmsn.me.uk

On 30/04/2010 16:35, Debbie wrote:
How would I do an IF statement where IF a check box is null then do
nothing but if yes, then enter a field.

This is what I am trying to do - { IF {MERGEFIELD FT Contract} = TRUE
(or "") then insert {MERGEFIELD "Start"} otherwise enter text "N/
A"} " }

This is the formula I am using but can't get it to work.

{ IF "{MERGEFIELD FT Contract}" = TRUE "{MERGEFIELD Start}" {"N/A"}
" }

I am thinking it is something like this but it does not work.
Any help would be greatly appreciated.
Thanks in advance.

Debbie