[thelist] replacing CRLFs in Memo fields

[Burhan Khalid]

Pringle, Ron wrote:
> Ok, two more related questions. I've googled around for this and haven't
> come across anything. (any links would be appreciated).
> 
> In my Access 2000 DB I have a memo field that will be taking input from a
> web form. The people using the form will most likely be cutting and pasting
> text from MS Word docs.
> 
> That memo field will in turn be displayed on the web. I want to preserve the
> paragraph formatting of the original text.
> 
> 1. How do I go about finding and replacing the CLRFs that are inserted in
> the form field with <p> tags?

If you are using PHP, you can use the nl2br() function which will do 
this for you (and you can preserve the original format in the database).

As its name suggests, it converts newlines to break tags.

Hope this helps