Chang Log Report logtext field

I'm building a report based on the ChgLog table. The LogText field seems to
have a return line in it or something. I'm trying to strip it out so that
the log text is all on one line.

I know chr(13) is a carage return and I have tried that but it doesn't seem
to work for me.

Any Ideas?


[Non-text portions of this message have been removed]