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?



~Charlie





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