Click to See Complete Forum and Search --> : Data Field not Truncating


Mariekd
March 18th, 2005, 03:57 PM
I have a data field in my report that needs to truncate when it is too long. I do not have "Can Grow" checked, but this field will still run over and interrupt other data.

I cannot reposition this field so it won't interrupt anything else.

Thanks for any help.

Madhi
March 21st, 2005, 12:14 AM
If the filed has too many characters without a space this may happen. To avoid this create a formula @MyField having the code
mid(Field,1,20)So only 20 charaters will be printed