Split into two text if overflow

[o2is4u]

Good Day

I am trying to create another text filed if the first one is overflow in a report.

Text= If my time was right I would have taken the chance to find another job but it was not possible since there was nothing available at that time

Text count for above is 147.

Text1 width =85 characters
Text1= If my time was right I would have taken the chance to find another job but it was not

Text2 width =85 characters
Text2= possible since there was nothing available at that time

Appreciate your kind help

 

[pbaldy]

You could use the Left() and Mid() functions, but are you aware of the Can Grow property?

 

[o2is4u]

Thanks pbaldy for your quick response.

My problem with can grow is it will hit another field. So I want to postion Text2 somewhere else with the overflow from Text1.

 

[pbaldy]

I suspect you haven't tried it, but those functions should let you do it your way.

 

[o2is4u]

I suspect you haven't tried it, but those functions should let you do it your way.

Hi Paul

I will reflect the can grow and using left and mid as suggested and note if the value is longer it might create a problem.

Can Grow
Ninety-Seven Million Five Hundred Sixty Thousand Nine Hundred Seventy-Six exactly ///\\\
=Left([Text86],75)
Ninety-Seven Million Five Hundred Sixty Thousand Nine Hundred Seventy-Six e
=Mid([Text86],76,8)+" ///\\\"
xactly ///\\\
Now if I change in Left or mid it will not work always.

Any clue please

 

[pbaldy]

You don't have to specify a length for the Mid() function. Left off, it will go to the end. That won't help when a word breaks in the middle, if that's a concern. The Can Grow property should not "hit another field". As its name implies, it will shift other fields down to accommodate the growth.

 

[David R]

You don't have to specify a length for the Mid() function. Left off, it will go to the end. That won't help when a word breaks in the middle, if that's a concern. The Can Grow property should not "hit another field". As its name implies, it will shift other fields down to accommodate the growth.

Which admittedly can be a problem if you've written your report with very little whitespace...

 

[o2is4u]

You don't have to specify a length for the Mid() function. Left off, it will go to the end. That won't help when a word breaks in the middle, if that's a concern. The Can Grow property should not "hit another field". As its name implies, it will shift other fields down to accommodate the growth.

Good Day

I followed your method Paul with bellow details
Text 1 Details
=Left([Text86],75)
And the Text 1 Box is positioned at (Left 5.45)

Text 2 Details
=Mid([Text86],67)
And the Text 2 Box is positioned at (Left 0.926)

It works for some arguments and not all. Whenever there are more words to be used it starts to show like the following

At The end of Text1 Three. Then at beginning of Text2 ee Thousand Two hundred. The “ee” should not appear supposedly.

I can’t use can grow cause there is another field immediately bellow which I should not move for printing purposes.

 

[pbaldy]

Well, the Mid() function should start with the next character, in your example 76. In any case, if the 2 text boxes are next to each other, why not just have 1 wide textbox?

 

[o2is4u]

Well, the Mid() function should start with the next character, in your example 76. In any case, if the 2 text boxes are next to each other, why not just have 1 wide textbox?

Thanks for your reply Paul

The 2 text boxes are not next to each other actually the second one is bellow to the left. I did try changing the Mid() to so many starts including 76 as you advised, yet the best was to set same to 67.

any help

 

[o2is4u]

Good Day

Any Help Please am totaly lost

 

[David R]

Did you ever try Can Grow on text1? I suspect it will do what you need without all the hocus pocus.

 

[David R]

The only time I've ever had trouble with it (and this may be fixed in later versions) is if I had the bounding boxes of two fields overlap/touch, the top one could not Grow. Even the slightest .05" whitespace was sufficient to fix it.