Need to limit Field Length in DRW

[Simon Ransom]

** Remove "simple_" to reply to me directly

Hi all

I have a memo field in Acces that i would like to display
on an ASP page but to limit the number of characters
displayed. Not sure if this needs to be done at Access
or FP end. You can look at
http://www.theransoms.com/tpsa/master.asp to see the
results. At the moment in the "News from the Live Events
Industry..." section odwn teh page the full news listing
shows and ideally i would like to automatically trim that
to show only the 1st 100 characters for example.
The "read more" link would then show the full memo field

Any ideas, guidance musch apprecaited.

Many thanks

Simon

 

[Thomas A. Rowe]

On the page try:

<%=Left(recordsetname("fieldname"),100)%>

--

==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, Forums, WebCircle,
MS KB Quick Links, etc.
==============================================