Hello, I'm a long time lurker who can normally get things to work from reading the excellent information from this site. I have run into an issue that I just can't put together and am hoping that posting specifics can help you help me.



I have a document that I'm trying to replicate with check boxes. The source field is named EthnicityRace and it contains the following choices in order:


American Indian or Alaska Native
Asian
Native Hawaiian or Other Pacific Islander
Black or African American
White


When one race is marked, my check boxes work fine using the following field code (using American Indian or Alaska Native in this example):




IF "{EthnicityRace}" = "American Indian or Alaska Native" "" "" \* MERGEFORMAT



The problem comes when multiple races are selected, the source outputs { string.Join("",EthnicityRace )} which produces Asian,White or Black or African American,White as examples.


How can I account for all variables in this scenario?


Thanks for any help!

Attached Images

Untitled.jpg (39.0 KB, 10 views)

There is no field test that would be practical for the scenario you describe. Your source data need to have either just one ethnicity choice in the Ethnicity field or multiple ethnicity fields (one for each possibility), each of which can be populated with, say, Y or N. The only workaround would be to output «EthnicityRace» as a string then use a macro that finds those outputs in the resulting merged documents and updates the existing checkboxes.

As for the example you gave, it could be expressed as:
{IF«EthnicityRace»= "American*" {SYMBOL 254 \f Wingdings \u } {SYMBOL 253 \f Wingdings \u }}
There is no need to write the choices out in full or for the \* MERGEFORMAT switch.

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

Thanks for the reply. I'm using this document as a template in a 2nd party application and don't think macros are allowed.



I guess I'll have to create individual Y/N fields for those choices.