Currently the text is being stored in a memo field using 2 carriage returns as a paragraph separator. In the asp page that actually displays it the cr's are replaces with <Br> i.e.
Synopsis = Replace(Synopsis,vbCrLf,"<br>"). If that could be used to determine the paragraph then that would be more useful than using left(). Thanks Alex Elger Micronage Ltd [EMAIL PROTECTED] -----Original Message----- From: Chris Tifer [mailto:[EMAIL PROTECTED]] Sent: 11 October 2002 4:44 PM To: ActiveServerPages Subject: Re: ASP Access and Displaying the first Paragraph How do you define a paragraph in the DB? Do you put linebreaks or is there HTML stored with this text? Chris Tifer ----- Original Message ----- From: "Alex Elger" <[EMAIL PROTECTED]> To: "ActiveServerPages" <[EMAIL PROTECTED]> Sent: Friday, October 11, 2002 2:55 AM Subject: ASP Access and Displaying the first Paragraph > I have an access DB which i have written an ASP front end for. > On my list page i would like to include a "Teaser" being the first paragraph > of what i have in the Synopsis column. > Is this possible and if so how would this goal be accomplished? > Thank you all for your time > Alex Elger > > > --- > You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] > To unsubscribe send a blank email to %%email.unsub%% > --- You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
