A
Arnold Klapheck
I am using access 2007.
I am displaying a multiple selection in a combo box on a report. I have named
it cboBSCCourse with it's control set to the field BSCCourse (it is a
multiple select lookup) in a bridge table. The number of items can be from 4
to 7 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
I have been trying to use the replace command like below but cannot get it
to work,
Since I am using a variable number of items I am thinking I might have to
use a loop to go through the items.
can someone help me to figure this out
should I put this in the control source of cboBSCCourse?
=Replace([BSCCourse],",",", " & chr(13) & chr(10))
I am displaying a multiple selection in a combo box on a report. I have named
it cboBSCCourse with it's control set to the field BSCCourse (it is a
multiple select lookup) in a bridge table. The number of items can be from 4
to 7 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
I have been trying to use the replace command like below but cannot get it
to work,
Since I am using a variable number of items I am thinking I might have to
use a loop to go through the items.
can someone help me to figure this out
should I put this in the control source of cboBSCCourse?
=Replace([BSCCourse],",",", " & chr(13) & chr(10))