Removing Line Breaks (returns) when exporting large field

[Andrew]

I am trying to create a report but I have a problem.

I have a field called course_description that is fairly long. I am trying to
export this field as a .rtf via Access Report. The problem is every time a
line is complete it adds a line break (think hitting return in word). So I
might have a course_description that is 6 lines long with six seperate
returns. I was wondering if there any way to get the field to export as a
solid block without the returns?

 

[Marshall Barton]

I am trying to create a report but I have a problem.

I have a field called course_description that is fairly long. I am trying to
export this field as a .rtf via Access Report. The problem is every time a
line is complete it adds a line break (think hitting return in word). So I
might have a course_description that is 6 lines long with six seperate
returns. I was wondering if there any way to get the field to export as a
solid block without the returns?

Export a calculated value:

Replace(course_description, Chr(13) & Chr(10), "")