Access & Form Data

[aleci]

Hi all,
1)Firstly I'm submitting information through a form field (form.title) and a TEXTAREA box (form.content)

2)Then i am entering the information into a DB using the SQL INSERT INTO/VALUES combination.

3)Finally i am outputting the DB info into a section of a web page.

My problem is that any formatting/paragraphs etc. that i use in the TEXTAREA box is lost when i output it!
Does anyone know a way round this - is it my Access configuration etc?

In case it helps my TEXTAREA bit looks like this:

<TEXTAREA NAME=&quot;content&quot; cols=&quot;40&quot; rows=&quot;10&quot; wrap=&quot;VIRTUAL&quot;>
</TEXTAREA>

Thanks!

 

[GunJack]

Hey Aleci,

Try this:

<cfoutput>#replace(query1.content,&quot;#chr(10)#&quot;,&quot;<br>&quot;,&quot;all&quot#</cfoutput>

By replacing the line breaks with a <br> tag, you should effectively reproduce the paragraph formatting on the page. You could also replace the tab character with &quot;&nbsp; &nbsp; &nbsp;&quot; to simulate tabs if you want to go that far.

Hope this helps,
GJ