I have a text field with large text. The problem is that the text appears huge in the reports. I know QB has some logic to include "More/Less" option for the text column to show/hide more text. Can anyone let me know if they have encountered this option and how to use it??
You can create a Formula Text field that will show the first 100 characters of the text field. You would replace the Text Field with the Formula Text field in the reports. Here is an example.
Left([text field], 100)
[text field] would be replaced with your Text Field name
var Text a = Left(<Field Name> ,50);
var Text b = NotLeft(<Field Name>,50);
If (<Field Name><>"",
" <a onclick=\"$(this).hide();$(this).next().show().next().show();\">More</a>" &
" <span style='display:none'>" & $b & "</span>" &
" <a style='display:none' onclick=\"$(this).hide();$(this).prev().hide().prev().show();\">Less</a>"