Forums
This topic is locked
Displaying sample of text from a database record
Posted 02 Oct 2002 01:21:28
1
has voted
02 Oct 2002 01:21:28 Allan Young posted:
I have managed to set up a recordset that will display the name, product code and description for an item within the database - I have also managed to link to a Master Detail Page. However, I would like the initial display to only show the first 40 - 50 characters of the description with the full text displayed in the Master Detail Page - anyone give me a clue as to how to do it? Thanks in advance.Replies
Replied 02 Oct 2002 01:52:10
02 Oct 2002 01:52:10 Owen Eastwick replied:
Try:
<%= Left(rsName.Fields.Item("FieldName"
.Value, 50) %>
Regards
Owen.
Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo
<%= Left(rsName.Fields.Item("FieldName"
.Value, 50) %>Regards
Owen.
Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo
Replied 02 Oct 2002 23:42:24
02 Oct 2002 23:42:24 Allan Young replied:
Very many thanks - worked a treat!