Hi,

I am trying to get a memo field of an MS Access database to show up in an asp with the line breaks (CR) between paragraphs.

The databse contains the breaks because in its former life, the data was displayed on an asp page generated by Frontpage (eeeeh...i know) and it looked fine.

How can i get these missing breaks back!?

Thanks

Remi

Hi Remi,

If I understand the problem correctly, simple replace each line break with its HTML equivalent. E.g.:

' Get data from DB first
Dim MyMemoText
MyMemoText = MyRecordSet.Fields("MyMemoColumn").Value

' Now replace stuff:
MyMemoText = Replace(MyMemoText, vbCrLf, "<br />" + vbCrLf)

This code will replace each line break in the database column (vbCrLf) with an XHTML line break and a normal link break.

HtH,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

Imar,

Simple problems have simple solutions!

Thanks!

Remi