If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Shorten (Truncate) Text Field?

01-14-2014, 06:19 PM

If you wish to truncate a text field you can use this little script I found on the internet (My thanks to the original Poster... whoever he was!)...

Problem: You have a several dozen large pieces of text in the form of a Notes.
You wish to display them in an Editable Grid but the notes are to large and cumbersome to be viewed in this manner.
Solution: In the editable grid, truncate the text displayed - you'll only see the full text if you Edit or View the Note Details.

Script: onLoadRecord Event

$string = {Note}; // Name of the Field
$len = 150; // Length of Truncated Text