formating multiple selection in report

[Arnold Klapheck]

I am displaying a multiple selection and it lists them out with a comma after
each one. I want it to to to the next line after the comma.

currently like this
item one, item two, item
three, item four

I want to look like this
item one,
item two,
item three,
item four

any suggestions? the items are various lengths.

 

[fredg]

I am displaying a multiple selection and it lists them out with a comma after
each one. I want it to to to the next line after the comma.

currently like this
item one, item two, item
three, item four

I want to look like this
item one,
item two,
item three,
item four

any suggestions? the items are various lengths.

Is this all within one field in one record a report?
=Replace([FieldName],",",", " & chr(13) & chr(10))

 

[Arnold Klapheck]

I tried
Private Sub BSCCourse_Open()
=Replace([BSCCourse],",",", " & chr(13) & chr(10))
End Sub

and I get err msg expected line number or label or statement or end of
statement

and it highlights the =

this is all inside a combo box

I am displaying a multiple selection and it lists them out with a comma after
each one. I want it to to to the next line after the comma.

currently like this
item one, item two, item
three, item four

I want to look like this
item one,
item two,
item three,
item four

any suggestions? the items are various lengths.

Is this all within one field in one record a report?
=Replace([FieldName],",",", " & chr(13) & chr(10))

 

[fredg]

I tried
Private Sub BSCCourse_Open()
=Replace([BSCCourse],",",", " & chr(13) & chr(10))
End Sub

and I get err msg expected line number or label or statement or end of
statement

and it highlights the =

this is all inside a combo box

I am displaying a multiple selection and it lists them out with a comma after
each one. I want it to to to the next line after the comma.

currently like this
item one, item two, item
three, item four

I want to look like this
item one,
item two,
item three,
item four

any suggestions? the items are various lengths.

Is this all within one field in one record a report?
=Replace([FieldName],",",", " & chr(13) & chr(10))

Just add an unbound control to the report.
Set it's control source to:
=Replace([BSCCourse],etc......)
as in my previous reply.

 

[Arnold Klapheck]

Just add an unbound control to the report.

Set it's control source to:
=Replace([BSCCourse],etc......)
as in my previous reply.

The original control is a combo box I have named it cboBSCCourse with it's
control set to the field BSCCourse in a bridge table.

I added an unbound textbox to the form and set its control source to
=Replace([cboBSCCourse],",",", " & Chr(13) & Chr(10))

and I get error message #Error

oh yea, the number of items can be from 4 to 7