VBCRLF within a table

Results 1 to 2 of 2

Thread: VBCRLF within a table

  1. #1
    Join Date
    Dec 1969

    Default VBCRLF within a table

    I have an form with a textarea box being submitted anx stored via ASP to an Access97 database. The corresponding field in the database is in MEMO format.<BR>How can I retrieve this field from the database and display it in a HTML Table Cell in its original format i.e with carriage returns etc..

  2. #2
    Markkk Guest

    Default RE: VBCRLF within a table

    Carraige returns are ASCII code 13, or CHR(13)<BR>Line feeds are ASCII Code 10, or CHR(10)<BR><BR>Try toying around and replacing all CHR(13) and CHR(10) characters with a simple HTML line break &lt;br&#062;.<BR><BR>Something like:<BR><BR>REPLACE(Memofield,CHR(13) & CHR(10), "&lt;br&#062;")<BR><BR>I hope thid helps!!

Posting Permissions

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