Thread: Formatting text

I have a content management system where the user has to put in match reports for a sport. I am using a text area to do this, then calling this text area via a form and placing it into my Access database.

The question is :

Is there a way to format the text when the user is putting it into the database so that they can use new paragraphs?

At the minute the report all comes out as one big piece of text in only one paragraph, however i would like it so the user can break up their report into different paragraphs

Originally Posted by mehere

they should be able to use line breaks and what not in the textarea. how are you inserting into the database ... and how are you displaying it?

Inserting the stuff through an sql string. Diplaying it as it was put into the textarea, altho when I use a new line in the textarea this is not displayed in HTML....think the reply below might be the solution to that problem. Thanks

Originally Posted by richyrich

A text area uses a vb carriage return to create a new line, vbcrlf. HTML uses <br> to create a new line. So, you have to replace one for the other when inserting into the database.

I'd suggest looking into rich text editors which allow the user to format HTML in a WYSIWYG style and then you can insert the full HTML into the database.

Hope that helps.

Is this what you are talking about?

Through The Web Rich Text (WYSIWYG) Editor

This is for php, although im using ASP. Would it be hard to change the code to ASP?