HELP with multiple if problem

[ondacreep]

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!