How to display values from a multivalue combo box on separate lines in a report?

[DAllen]

I have a combo box in a form whose Control Source allows multiple values. In the form, I'm able to show the selected values on separate lines by selecting "New Line" under "Separator Characters" under the combo box's Property Sheet. I also have a report where I want to display these values on separate lines. In the report, I have a text box with the multiple value field as its Control Source. However, it will only display the values on the same line, separated by a comma. How can I get those values to display on the report on separate lines?

[CJ_London]

I have a text box with the multiple value field as its Control Source.

I don't use multivalue fields due to their limitations, but I believe the controlsource needs to be

multivaluefieldname.value

I also think you need to bring this through in your recordsource , don't think you can access it from your report

[ssanfu]

Also see http://allenbrowne.com/ser-29.html Tip #10

[June7]

Need a better understanding of what multi-value field is and how to manipulate. https://support.office.com/en-us/art...3-b6624e1e323a

I also have never used.