Concatenate multiple check boxes into textbox with commas/ands

[Vethra]

Hi all,



I have 20 checkboxes and would like the checked to appear into a textbox like so: Adaptor, Welding Flange, Pipe and Hanger.


I have put this in my control source but it doesn't work the way I want it too.
=IIf([Checkbox1],"Adaptor") & IIf([Checkbox2],", Welding Flange") & IIf([Checkbox3],", Pipe")& IIf([Checkbox4],"and Hanger") and so on..........

Currently if checkbox1 is clear the text box will appear like so: ", Welding Flange, Pipe and Hanger" with a unwanted comma. Also I would like the last item in my text box to appear like so: "and Hanger"

Does anyone know of any VB or anything that might help?

Thank you,
Dilan

[ssanfu]

You will have to create a sub to create the string. I would use an array and loop through the check boxes. Then replace the last comma with "and".
Kind of like creating a filter on the fly.




Edit.... I created an example

[Vethra]

That is exactly what I was looking for thank you very much ssanfu

[ssanfu]

You're welcome.
All you should have to do is add the names to the array. and the names must be in the same order as the check boxes.

Good luck with your project.


Ready to mark this solved??