Forums
This topic is locked
Inserting text fields into Access / line returns
21 Jan 2002 11:52:57 Stefan P posted:
I am building a site with input pages that submit various fields to Access. This info is then presented in another ASP page. I would like the fields to preserve the line returns that are entered on the input page. How can I do this??Thanks
Sesame
Replies
Replied 21 Jan 2002 13:05:33
21 Jan 2002 13:05:33 Owen Eastwick replied:
Use a multi line textfield to input the text to a memo field in your database.
When you display the text.
Replace this:
<%=(RecordsetName.Fields.Item("MemoFieldName".Value)%>
With this:
<%= Replace(RecordsetName.Fields.Item("MemoFieldName".Value, VbCrLf, "<BR>"%>
Regards
Owen.
Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo
When you display the text.
Replace this:
<%=(RecordsetName.Fields.Item("MemoFieldName".Value)%>
With this:
<%= Replace(RecordsetName.Fields.Item("MemoFieldName".Value, VbCrLf, "<BR>"%>
Regards
Owen.
Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo
Replied 21 Jan 2002 15:40:44
21 Jan 2002 15:40:44 Stefan P replied:
Thanks Owen, exactly what I needed.
Regards
Sesame
Regards
Sesame
Replied 24 Jan 2002 20:44:34
24 Jan 2002 20:44:34 Mitchel Tendler replied:
Thanks OWEN!!!!!
WHoo Hoo!!!!!
When in doubt...reboot!
WHoo Hoo!!!!!
When in doubt...reboot!