Getting rid of special characters on reports

[Lifeseeker]

Hi,

I have a report, which contains a memo field.

When the report is ran, the columns show characters such as <br>, <linebreaks>, etc.

Is there any way to get rid of them and only show the content?

Thanks

 

[boblarson]

Did you change the text box's text type from PLAIN TEXT to RICH TEXT? It sounds like you have Rich Text in the table, so it would need to have that property changed for the text box on the report as well.

 

[Lifeseeker]

Hi Bob,

It did not solve the problem.

I checked both the backend and the report, the memo fields are set to "rich text".

I wonder if it has to do with format option. Sometimes it has a little "@" character in the format option field in table property, but I"m not sure.

 

[boblarson]

A Rich text field shouldn't have anything in the format property of the field or text box. If they have something, remove it.