Forums
This topic is locked
Displaying sample of text from a database record
Posted 22 years ago
1
has voted
22 years ago 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 22 years ago
22 years ago 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"

Regards
Owen.
Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo
Replied 22 years ago
22 years ago Allan Young replied:
Very many thanks - worked a treat!