Report Builder Return character

M

mnafehm

I am creating a report in access the problem that I run into is it's
calling these field values stored in SQL (which stores a
"return/enter" value in one row) and when this field is displayed
in report it comes horizontally with a "return" character (square
shaped box) is there a way to specify to return that value in another
line?

=IIf(IsNull([MissingItem1]),"",[MissingItem1])

Thru my understanding of reading up on things I tried

=IIf(IsNull([MissingItem1]),"",[MissingItem1] & Chr(13) & Chr(10))

And that didn't seem to yield any results

Note: MissingItem one has multiple values listed in it divided by a
return character

Thank you
 
Top