Forums
This topic is locked
Inserting text fields into Access / line returns
23 years ago 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 23 years ago
23 years ago 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"

With this:
<%= Replace(RecordsetName.Fields.Item("MemoFieldName"


Regards
Owen.
Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo
Replied 23 years ago
23 years ago Stefan P replied:
Thanks Owen, exactly what I needed.
Regards
Sesame
Regards
Sesame
Replied 23 years ago
23 years ago Mitchel Tendler replied:
Thanks OWEN!!!!!
WHoo Hoo!!!!!
When in doubt...reboot!
WHoo Hoo!!!!!
When in doubt...reboot!