Database results using Access database

I am querying an Access database using the database results webbot. The results format shows each field in the result set. One of those fields is a memo field (formatted as LONGVARCHAR). However, when the results are presented to the screen, all the formatting (e.g., paragraphs) is gone, and that field is one long run-on text. Is there a way to keep the formatting when presented to the screen via the database results?
DARRAHAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mSHCommented:
Asume that your field name is "user". Look in HTML source code, you'll see this line. (Each line is representing for a field in the recordset)

<%
If Not IsEmpty(fp_rs) And Not (fp_rs Is Nothing) Then Response.Write CStr(fp_rs("user"))
%>

You have to change it like this:
<%
If Not IsEmpty(fp_rs) And Not (fp_rs Is Nothing) Then Response.Write Convert(CStr(fp_rs("user")))
%>


And the funtion Convert is:
<%
  Function Convert(strSource)
     strDest = strSource

'Add newline tag
     strDest = Replace(strDest, Chr(13), "<br>"&Chr(13))

'Change multi space into space tag
     strDest = Replace(strDest, "  ", " &nbsp;")
     strDest = Replace(strDest, "&nbsp; ", "&nbsp;&nbsp;")
     Convert = strDest
  End Function
%>


0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
DARRAHAuthor Commented:
Awesome!!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Web Development Software

From novice to tech pro — start learning today.