AnsweredAssumed Answered

Remove empty fields (with bullets) in a 'Merge Field'

Question asked by markgordie on Oct 29, 2013
Latest reply on Oct 29, 2013 by markgordie

Title

Remove empty fields (with bullets) in a 'Merge Field'

Post

     I am able to create a list with bullet by creating a single field [Outcome_Lists] with the following calculation:

     Char (8226) &  " "  & Outcomes & "¶" & Char (8226) &  " "  & Outcomes Copy & "¶" & Char (8226) &  " " &  Outcomes Copy2 & "¶" & Char (8226) &  " "   & Outcomes Copy3 & "¶" & Char (8226) &  " " & Outcomes Copy4 & "¶" & Char (8226) &  " " &  Outcomes Copy5

     This give me a list with a bullet in front of each line.  However, not all the fields within this calculation are necessarily populated.  On a blank layout, I inserted a text box with a Merged Field [Outcome_List] with the above calculation.  The problem is, every field from the calculation is inserted on the layout due to the fact there is a bullet in each field.  

     My question is, is there a way to remove the fields that do not have any data (other that the bullet) removed from the layout or at least when you go into Preview?

     Thank you,

     Mark

Outcomes