Retrieving Formatted Text

[MikeyF]

Hi

I have done an application where you fill out an Active Server Page then send it to an SQL 7.0 server then retrieve in amnother page - working fine !!

My problem is - can I have a field that users can enter text with formatting such as line breaks paragraphs etc.. then return with the formatting intact - I have tried this by every time I get back one big string of text and the formatting has been stripped out.

Is there a way round this

Any help gratefully recieved

Mike

 

[ResolutionsNET]

If you store the information asd a text field, rather than a char or varchar it will work.

 

[MikeyF]

Many thanks