Help, I've been trying for days to get this one off the ground - I need to get carriage returns and bullet points into my access database from a form.

Story so far: Ive created the form which (form.asp) which connects to my db (form.mdb). When retrieving the information, the carriage returns dont come true. News is the name of the memofield.

Code:
  <%
   ' Declaring variables
   Dim rs, data_source, strText

   data_source = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & _
            Server.MapPath("form.mdb")

   ' Creating Recordset Object and opening the database
   Set rs = Server.CreateObject("ADODB.Recordset")
   rs.Open "users", data_source, strText

    strText = Rs("news")
    strText = Replace(strTExt,vbCrLF,"<br>")
    %>

I'd be grateful if someone could help. Please

Are you using textarea to get the information "news"?

Om Prakash

Thanks for your quick reply - I'm trying to retrive it from a memo field in the database.

The area which I want to draw the info into is:

<td colspan="5"><p class="bluetextmr"><%=rs("news") %></p></td>

]
Sorry misunderstood initially, yes I am using the text area in the db - am assuming the user doesnt know html so cannot expect them to use coding in the form. I've tried all sorts of ways of replacing but cant seem to crack it. Any help appreciated. Thanks.

Try this

Or
Actually, you should be converting them to <br> tags while inserting into DB, that is when your code should replace vbCRLFs to <br>s
But still it depends on the usage, if you are not using these data for the purpose other than displaying on the webpages, then you can replace that into <BR> tags while inserting into DB, else you should be doing it the way I mentioned above.

Hope that helps.
Cheers!

_________________________
- Vijay G
Strive for Perfection

OMG Vijay - Its worked - thank you ever so much. One happy bunny here... :D

[quote]quote:Originally posted by happygv


Actually, you should be converting them to <br> tags while inserting into DB, that is when your code should replace vbCRLFs to <br>s
But still it depends on the usage, if you are not using these data for the purpose other than displaying on the webpages, then you can replace that into <BR> tags while inserting into DB, else you should be doing it the way I mentioned above.

------------------------
Hope you dont mind me asking - I did try to put this in the submit form as such previously

   Function ChkString(string)
   If string = "Chr(13)" Then string = " "
   ChkString = Replace(string, "Chr(13)", "<br>")
   End Function

but I couldn't get it to work as it is a form to submit to the database just to be viewed as an html page.
Thanks. Deb

You should not use "" around chr(13)

You can also use vbCRLF there instead of chr(13), but still without "" around it.

or
Cheers!

_________________________
- Vijay G
Strive for Perfection

It makes sense now. Thanks ever so much Vijay. Phew!