Crystal Reports - formula to wrap text after 10 characters.

jessieBoo
jessieBoo used Ask the Experts™
on
I need create a formula the will allow me to control when to wrap text. I'm looking for a formula that I can put in the 'Can Grow' section to determine this. I cannot use the the text sixe to limit the characters.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
I think you will have to explain in more detail what you are trying to do.

You can use a code loop to add a Chr(10)  -new line-  every 10 characters .
Is that what you want?

Author

Commented:
No I want to be able to set the number of characters when a wrap of text will occur. Like after every 10 characters wrap text.
I don't see the difference between 'wrap every 10 characters' and 'newline every 10 characters'?
Become a CompTIA Certified Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

Author

Commented:
What I'm trying to do is where you set 'Can Grow' there is a formula button.

I need to know how to set the number maximum number of lines in a formula based on the size of the string in the text box.
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Commented:
You can't as best I can tell control the numer of lines from that formula.  It requires the result to be a boolean to indicate whether the field can grow or not.

Why do you want to control it?
If set to 0 it will grow as needed.

mlmcc

Author

Commented:
complicated to explain here why. Just need to do it.
Senior Consultant
Most Valuable Expert 2011
Top Expert 2013
Commented:
I don't think it is possible.  I don't know of any way to access that value from a formula.

Are you overwriting something below?

Is the growth causing an unwanted page break?

mlmcc

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial