Forums
This topic is locked
ASP and Access
Posted 07 Dec 2004 04:01:27
1
has voted
07 Dec 2004 04:01:27 Javier Castro posted:
Hi,I made a website using ASP and MS Access in the back-end. One of the functions of the website is to post some news by using a web based form. Copy, paste, submit and voila! It works fine, However, Since it is mainly text that is pasted on the form, I would like to be able to keep the original formatting of the text and not to have it displayed, as is now, all together without spaces. Can anyone tell me how to achieve that wonderfull thing. Is it an Access problem or an ASP thing?
Cheers.
Replies
Replied 07 Dec 2004 16:43:36
07 Dec 2004 16:43:36 Dave Thomas replied:
use the replace function.
a simple search of the forums could have found you many other questions like this.
<pre id=code><font face=courier size=2 id=code>
<%= Replace((RecordsetName.Fields.Item("FieldName".Value),vbcrlf, "<br>" %>
</font id=code></pre id=code>
and replace "FieldName" with the name of your textbox.
Regards,
Dave
[DWMX 2004]|[FlashMX 2004 Pro]|[SQL]|[Access2000]|[ASP/VBScript]|[XP-Pro]
a simple search of the forums could have found you many other questions like this.
<pre id=code><font face=courier size=2 id=code>
<%= Replace((RecordsetName.Fields.Item("FieldName".Value),vbcrlf, "<br>" %>
</font id=code></pre id=code>
and replace "FieldName" with the name of your textbox.
Regards,
Dave
[DWMX 2004]|[FlashMX 2004 Pro]|[SQL]|[Access2000]|[ASP/VBScript]|[XP-Pro]