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
Replied 22 years ago
22 years ago Allan Young replied:
Very many thanks - worked a treat!

Reply to this topic