Removing comma/blank from concat

[EmAlbritton via AccessMonster.com]

Good Afternoon!

I have gotten my concat field to work...finally. The problem I am having now
is not having all the commas from null fields display.

The control source for my unbound text box on my report is as follows. This
refers to text boxes that convert true check boxes to text information.
=&([TextBAT]) & (", " + [TextBATConf]) & (", " + [TextBlood]) & (", " +
[TextDIPOnly]) & (", " + [TextDNASaliva]) & (", " + [TextETOHSaliva]) & (", "
+ [TextHair]) & (", " + [TextLabUDS]) & (", " + [TextRapidUDS]) & (", " +
[TextUnknown])

Each of the Text boxes above have the same relative control source as:
=IIf([BAT]=-1,"BAT","")

Is it possible that the "false" result of the above is causing my problems
with the comma in the concat?

Thanks in advance for any thoughts.

Emily

 

[Duane Hookom]

You might get an adequate solution to this question but the issue of your
un-normalized table structure is not resolved. This has been explained in
the earlier thread you began for this same basic issue.