Jonathan, Try making it a Memo, instead of Text.

Matthew
--
Matthew Ohlman
http://www.ohlman.com/
Professional, Affordable web pages
Reply to: matthew(at)ohlman.com
Business: ohlman(at)ohlman.com
"There's a difference between Philosophy and a bumper sticker"
  Charles Schultz



----- Original Message -----
From: "Hough, Jonathan (TWIi London)" <JHough(at)twii.net>
To: <hwg-languages(at)hwg.org>
Sent: Friday, September 06, 2002 10:05 AM
Subject: RE: ASP/VBScript: VbCr to <br> and MS Access


> on a similar MS Access tip - does anyone know if theres a way to store
more
> than the maximum 255 characters in a field?
>
> -----Original Message-----
> From: Shull, Conrad [mailto:cshull(at)shscares.org]
> Sent: 06 September 2002 15:21
> To: hwg-languages(at)hwg.org
> Subject: ASP/VBScript: VbCr to <br> and MS Access
>
>
> I store <textarea> submitted info in an Access memo field.  Before I
INSERT
> or UPDATE the field, I do a [ replace("text", VbCr, "<br>") ] so as to be
> able to show hard returns (paragraphs) when the text is later displayed on
a
> webpage.  However, I want to be able to trim all training returns that the
> user who entered the text might have inadvertently added.  The problem is
> that Access stores the replaced text as "<br>|" (the | character being the
> rectangular box that ASCII uses to display a carriage return.)  I can't
seem
> to "capture" "<br>|" for replacement with "".  Any advice?
>
> Conrad Shull
> Application Analyst
> Susquehanna Health System
> 570.321.2953
>
>
> DISCLAIMER - The preceding e-mail message (including any attachments)
> contains information that may be confidential, may be protected by the
> attorney-client or other applicable privileges, or may constitute
non-public
> information.  It is intended to be conveyed only to the designated
> recipient(s) named above.  If you are not an intended recipient of this
> message, or have otherwise received it in error, please notify the sender
by
> replying to this message and then delete all copies of it from your
computer
> system.  Any use, dissemination, distribution, or reproduction of this
> message by unintended recipients is not authorized and may be unlawful.
The
> contents of this communication do not necessarily represent the views of
> this company.

HWG: hwg-languages mailing list archives, maintained by Webmasters @ IWA