ASP/SQL INSERT statement

[Daniel ~]

So would I dear one so would I!

[ByteWipe]

Bump.

Right, back to my alevel project, which is coming along nicely. This isn't a problem I'm about to discuss as such, just a way of making the project seem that little bit cooler

On the same page the form contains one text field and a textarea field. When the user enters data into the textarea field, he may press enter a few times to seperate paragraphs, etc. However, when the data is submitted into the database, all formatting is removed and it just goes into one large string. The field in the database (Access 2000) is of 'memo' format.

This becomes a problem when another user wants to pull the submitted data and place it on to a webpage....there is completely no formatting! Is there a way to encode the data in the textarea field so that it contain HTML tags such as <P> and <BR>?

Thanks in advance...