Display Access memo field

Display Access memo field

am 28.09.2005 01:19:46 von Vincent Lau

Hello,
I'm new on ASP and Access. I stored several lines of information in a Access
memo field.

I use follow ASP response.write statement to display contain of the memo
field.
Response.Write sa1("job_detail")

However, all the lines are mixed into one line. How can I show it in the
original format?

Thanks

Re: Display Access memo field

am 28.09.2005 02:25:39 von Chris Hohmann

"Vincent Lau" wrote in message
news:dhcls3$mej$1@news.hgc.com.hk...
> Hello,
> I'm new on ASP and Access. I stored several lines of information in a
> Access memo field.
>
> I use follow ASP response.write statement to display contain of the memo
> field.
> Response.Write sa1("job_detail")
>
> However, all the lines are mixed into one line. How can I show it in the
> original format?
>
> Thanks
>
>

Response.Write "

" & sa1("job_detail") & "
"

Re: Display Access memo field

am 30.09.2005 00:20:59 von SteveB

varFld = sa1("job_detail")

' Convert all vbCrLf to
.
' (This is the same as converting Chr(13) & Chr(10) to
.)
varFld = Replace(varFld, vbCrLf, "
")

Response.Write varFld

Best regards,
J. Paul Schmidt, Freelance Web and Database Developer
http://www.Bullschmidt.com
Classic ASP Design Tips, ASP Web Database Sample

<<
I'm new on ASP and Access. I stored several lines of information in a
Access
memo field.

I use follow ASP response.write statement to display contain of the memo
field.
Response.Write sa1("job_detail")

However, all the lines are mixed into one line. How can I show it in the
original format?
>>

*** Sent via Developersdex http://www.developersdex.com ***