line breaks missing when displaying database record

[eljacobs]

Hi Guys

I have entered a record into an access datbase that has several paragraphs. However, when i display the record in a page the text is displayed as one long paragraph with no line breaks. The formatting has saved in the database so the problem occurs when the record is displayed.

Any advice on how to solve this problem is much appreciated.

Elliot

 

[FesterSXS]

This has been answered many times before and I'm sure there is an FAQ on the subject.

Replace(objRS("MyTextField"),vbcrlf,"<BR>")

Tony
________________________________________________________________________________

http://www.SpiraxSarco.com