Only display first 15 char's in field

[goldfish]

I 've made a database with 3 fields one is an id_field, name_field, and one which is notes_field which can hold max. 55000 characters as memo field.

The input-form works fine.

But when I display the records in a table view it runs out of screen if there is alot of data in the notes field. Is it possible I can make a change to display only the first 15 characters of the field. What is the php code to do this?

[corey]

Give this a try:

In this example table1 there are only two fields, one is rec_id and the second is NOTES and is a text field.

To truncate the notes text to 15 chars shown in the table view for the NOTES Field
LEFT(table1.NOTES, 15)

Query = "select table1.rec_id as 'Record ID', LEFT(table1.NOTES, 15) as 'NOTES' from table1";

hope this helps