Split Comma Separated Text on Separate Lines of Texbox

[priceman31]

I have very limited skills when it come to VBA. I am trying to break each part of a comma separated string into a form field with each comma separated value on it own line.
For example the field name is Tester and a single string value would be stored as blue, red, orange, black, green. What I want to do is separate each value on a new line but still in a single form field.

The Form field (Text Box) ideally would look like blue,
red,
orange,
black,
green,

I hope that makes sense.




I have tried using the Split function but have been able to figure out how to get each value on its own separate line. Any help would be greatly appreciated.

[June7]

Expression in textbox:

= Replace(Nz([Tester],""), ",", "," & Chr(13) & Chr(10))

If you don't really need the comma at the end of each line then don't concatenate it.

Is there a space following the comma?

[priceman31]

When I tried that I got a #size error. Not sure if I did something wrong. I even tried removing the extra comma at the end and no luck.

[priceman31]

I got it working...thanks