suppressing trailing commas when field is null

[jburris]

I am writing a report that needs to list 4 installment pay dates. I
have If-then statments in text boxes that set the installment pay date
to null if the installment date has passed. Say that the if-then
commands are in text boxes 1-4. The dates go from soonest to latest,
1-4 respectively.

Of course when I construct the following text box "=[text1]&",
"&[text2] . . . , I am left with hanging commas as the earliest dates
become null in the if-then statements.

My question is, how do I suppress the trailing commas. I tried doing
"=([text1]+", ") &(text2]+", ")& . . . but it only worked for the
first text box - and would suppress the first comma. When I applied
more than one text box I would get an error.

I don't want to list all the individual text boxes one on top of the
other because then I am left with empty spaces where the first dates
were before they became null. I have already set the can shrink
commands on the text boxes and the report section. Since I have other
fields in this section, the effect of the shrink command does not work.

Thanks in advance for any help.

Judy