Forums

This topic is locked

Inserting text fields into Access / line returns

Posted 21 Jan 2002 11:52:57
1
has voted
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
Replied 21 Jan 2002 15:40:44
21 Jan 2002 15:40:44 Stefan P replied:
Thanks Owen, exactly what I needed.

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!

Reply to this topic