I am inserting Below text into a "Access memo" field. I am using scrolling 
textbox to insert this text. Part of the requirement is each bullet should 
be displayed in next line while displaying from database. any easy way to 
do this? Thanks in advance.
------------------------------------------------------------------
Responsibilities: ? marketing new and renewal business to insurance 
carriers ? providing day-to-day client service ? analyzing coverage and 
exposure issues for commercial accounts, including contractors. 
-------------------------------------------------------------------

When you display the data, do a replace.  Like so:

<%
' Assuming you have a recordset object with a field named AccessMemo
Dim myStr
myStr = oRS("AccessMemo")

myStr = Replace(myStr,"*","<br>*")

Response.Write(myStr)
%>


I'm not sure if that will work, but I think it will. :)
Pete


-----Original Message-----
From: Chirag Shah [mailto:chiragiit@y...]
Sent: Wednesday, October 30, 2002 3:42 PM
To: ASP Databases
Subject: [asp_databases] something perplexing


I am inserting Below text into a "Access memo" field. I am 
using scrolling 
textbox to insert this text. Part of the requirement is each 
bullet should 
be displayed in next line while displaying from database. any 
easy way to 
do this? Thanks in advance.
------------------------------------------------------------------
Responsibilities: * marketing new and renewal business to insurance 
carriers * providing day-to-day client service * analyzing coverage and 
exposure issues for commercial accounts, including contractors. 
-------------------------------------------------------------------

When "displaying from database", are you displaying this in a browser? If
so, then you need to put the appropriate HTML tags in (eg replace the
bullets with <li></li> etc).

If you are displaying in a Windows app, you need vbCrLf (or Chr(10) &
Chr(13))

Cheers
Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Chirag Shah" <chiragiit@y...>
Subject: [asp_databases] something perplexing


: I am inserting Below text into a "Access memo" field. I am using scrolling
: textbox to insert this text. Part of the requirement is each bullet should
: be displayed in next line while displaying from database. any easy way to
: do this? Thanks in advance.
: ------------------------------------------------------------------
: Responsibilities: ? marketing new and renewal business to insurance
: carriers ? providing day-to-day client service ? analyzing coverage and
: exposure issues for commercial accounts, including contractors.
: -------------------------------------------------------------------

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~