Increasing the height of a text box

[bearcub]

I have a report where we sometimes have names in a text box that crashes into the one next to it. This only happens for one or two offices and we can't change the print width.

I have Can Shrink and Can Grow set to Yes but it doesn't prevent a name of one of our offices from getting meshed in with another one.

I was hoping to find something that would increase the height of the text box (like entering alt enter in a cell in Excel) so that this would office would be spread across two lines as opposed to one long one that smashes into the adjacent text box.

Thank you for you help in advance,

Michael

 

[Micron]

Meshed horizontally? I don't follow what the problem is, unless the box is just too wide anyway. If you look at it in design view and it encroaches/overlaps the one to the right of it, then it will crowd or overlay data. If you have Can Grow set to Yes, then what else could you need that will increase the height when it gets filled horizontally?

 

[bearcub]

I think you hit the issue on the head. It does overlap another text box. If I were to shorten the name text box (the one that's creating the issue) then it will should expand (insert a new line) when it runs out of space, correct?

 

[Micron]

Expand vertically, yes, as long as you have Can Grow set to yes. It should insert a line break between complete words if I recall (as long as no one word takes up more than an entire line).
I don't foresee a need to have Can Shrink also set to yes based on what you've written.