Removing Line Breaks (returns) when exporting large field

  • Thread starter Thread starter Andrew
  • Start date Start date
A

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?
 
Andrew said:
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?
Click to expand...

Export a calculated value:

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