I have a formula that if the count of the characters are > than 40, then trim it at 37 and add ... (dot dot dot). This would allow me to better use the realestate and visualy let me know that there is some more text in that field. This works great if all records were CAPS or all were lowercase, but not when one record is CAPS and other are lowercase.

I would like all my descriptions to have the ... as close to the end of the report field as possible.

 

Ok, without using font that doesn't vary in length or without converting to lowercase, how can I accomplish this?

 

I found some code where people were attempting this already, but not sure if I can use this concept in crystal.

 

Or I could make some complex formula that would count the CAPS characters and make that formula shorter or look for wide characters like M,W, etc. but I would perfer not to.

 

Any ideas would help?

Thanks, Tommy