Hi guys/gals! I hope spring is on a good start for everyone. I got a itch that needs scratching...

I am unable to find a solution on the net and hoping you can help.

I CR2008 that have 6 tables linked by specific fields. In the end, I have a text box that will be a description of an item or items such as follows:
(propdesc, color1, color2, make, model, year, serial, state)

All that is inside the text box and are separated by a comma. However, there are fields that have no data. How can I trim out those fields that are blank so that I don't see the following:
(GUN, BLACK,,HIGH POINT,,0,,)

I tried the Trim function but it is not producing the proper results.

Thank you all for your time and tips.

Gil