issue formatting out put

[jbird5k]

i have an app that stores text from a form, in a data base field called RESPONSE.  the form field is either a text input or textarea.  My issue is that the customer enters both paragraph text and list text in the same field.  When i out put this in  report they want to see:

some text, some text some text some text some text

item 1  
item 2
item 3
and currently they  see two paragraph on with the list items strung end to end.

is there a way that i can take the data and on out putting it display the paragraph as a paragraph and the list items as a list?

currently using paragraphFormat(response) which works great as long as response is not a list.

any suggestions?

[Dan_Bracuk · Accepted solution]

Doing it this way:

#replace(HTMLEditFormat(response), chr(10), "<br />", "all")#

has the following advantages.

It will display more or less as entered.

Javascript will display instead of execute.

Angle brackets used as math symbols will display properly.

[jbird5k]

Thanks, that worked great.

JBird