Forums

This topic is locked

Inserting text fields into Access / line returns

Posted 23 years ago
1
has voted
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
Replied 23 years ago
23 years ago Stefan P replied:
Thanks Owen, exactly what I needed.

Regards

Sesame

Replied 23 years ago
23 years ago Mitchel Tendler replied:
Thanks OWEN!!!!!


WHoo Hoo!!!!!

When in doubt...reboot!

Reply to this topic