[David A Wood]

Great replies - thanks to both of you for the assistance - priceless!!

Regards

David


"Graham Mayor" wrote:

If you use only 2 IF tests, ignoring the test for 'Not Applicable' then you
cannot go back and change your mind to Not Applicable from one of the other
selected options. The value of the IF field will remain until a different
value is forced upon it.

I agree about the \*lower case switch with dropdown fields but I was
demonstrating the wider point about the importance of case - this being one
of the problems in the OPs version..

I agree also that you can shorten the text with the wildcard, but my
personal preference is not to do so unneccesarily, as it is then easier for
a third party - or me for that matter - who may later need to edit the
form, to see what was intended.

--

Graham Mayor - Word MVP

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



"macropod" wrote in message
...
You could actually reduce the coding to just two IF tests:
{IF{Article21Dropdown}= B* "The responsible person had ensured that his
employees were provided with adequate safety training in a manner
appropriate to the risk identified by the risk assessment."}
{IF{Article21Dropdown}= Non* "The responsible person had not ensured that,
where a dangerous substance was present in the premises, the risk to
relevant persons was eliminated or reduced so far as was reasonably
practicable."}

Notes:
1. The field coding shows the absolute minimum code you'd need for the
tests.
2. I've separated the fields into separate lines here for clarity but, in
practice, they'd go on the same line.
3. I've omitted Graham's case conversions - with dropdown formfields there
should never be any doubt as to the case of the chosen response.
4. All the field brace pairs (ie '{ }') are created via Ctrl-F9 - you
can't simply type them or copy & paste them from this message.


--
Cheers
macropod
[Microsoft MVP - Word]


"Graham Mayor" wrote in message
...
There are a few issues in your example
1. The first dropdown entry is 'Broadly Compliant' yet your IF field is
looking for 'Broadly compliant'. The searches are case sensitive. To get
round that add a \*Lower formatting switch and put the search all in
lower case (see later)
2. {IF(Article21Dropdown} = " Non compliant - minor risk " has unwanted
spaces between the quotes and the text.
3. As the major and minor risk options reproduce the same text you can
use a wildcard in the search e.g. = "non compliant*"
4. It probably makes better sense here to use a sequence of conditional
fields on the same line rather than nested fields as there are only four
possible results from three conditional fields.
Thus:

{ IF { Article21Dropdown \*lower } = "not applicable" ""}{ IF{
Article21Dropdown \*lower } = "broadly compliant" "The responsible person
had ensured that his employees were provided with adequate safety
training in a manner appropriate to the risk identified by the risk
assessment. " }{ IF{ Article21Dropdown \*lower } = "non compliant*" "The
responsible person had not ensured that, where a dangerous substance was
present in the premises, the risk to relevant persons was eliminated or
reduced so far as was reasonably practicable."}

--

Graham Mayor - Word MVP

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




"David A Wood" wrote in message
...
Hi

I have a field with 4 choice answers in a dropdown list

"Not Applicable"
"Broadly Compliant"
"Non compliant - minor risk"
"Non compliant - major risk"

Using multiple "IF" I have used the following code -

{IF{Article21Dropdown} = "Broadly compliant" " The responsible person
had
ensured that his employees were provided with adequate safety training
in a
manner appropriate to the risk identified by the risk assessment. "
{IF(Article21Dropdown} = " Non compliant - minor risk " " The
responsible
person had not ensured that, where a dangerous substance was present in
the
premises, the risk to relevant persons was eliminated or reduced so far
as
was reasonably practicable." {IF{Article21Dropdown} = "Non compliant -
major
risk" "The responsible person had not ensured that, where a dangerous
substance was present in the premises, the risk to relevant persons was
eliminated or reduced so far as was reasonably practicable." " "}"}"}

The aim?
"Not Applicable" - returns blank
"Broadly Compliant" - returns "The responsible person had ensured etc"..

Next two choices return the same text line "The responsible person had
not
ensured that,... etc"

Have succeeded with a three state IF but failed with this..

Thanks for any help forthcoming.

















.