No line breaks in memo fields

Results 1 to 3 of 3

Thread: No line breaks in memo fields

  1. #1
    Mark Lium Guest

    Default No line breaks in memo fields

    I&#039m sure this is in an FAQ somewhere but I can&#039t find it. When displaying the contents of a memo field in an Access db (SQLSvr as well) there are no line breaks. Just one long string of characters. Any way to add line breaks before displaying the memo field contents on my ASP page? Thx.

  2. #2
    Manpreet Guest

    Default RE: No line breaks in memo fields

    yes u can.<BR>i assume that u are using a texbox or textarea in html from which u r getting the contents to fill in the memo field . if so then try the following when displaying the memo feild on HTML..<BR><BR>txt2show = Replace(rs("memo_field"),vbCrLf,"<BR>")<BR><BR>whe re rs is ur recordset whoich u get by quering the db<BR><BR>hope it helps!!<BR><BR>

  3. #3
    Mark Lium Guest

    Default RE: No line breaks in memo fields

    That worked PERFECTLY. Thank you very much!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •