Textbox - Wrap text onto second line for long fields

[Paul Kraemer]

Hi,

I have a (Access 2000) report that has a textbox in the group footer
section. I have a formula in this textbox that concatenates two string
fields. Sometimes (but not very often), the length of these two string
fields is long enough that the concatenated text does not completely fit in
the text box. In these cases, I was wondering if I could automatically
increase the height of the textbox and have the text wrap onto a second line.
I tried setting the "Can Grow" property to yes for both the text box and the
group footer section, but doing this did not help.

Any help will be greatly appreciated.

Thanks in advance,
Paul

 

[Jeff Boyce]

Paul

If there are any objects directly aligned and to the right, they constrain
the ability of your textbox to Grow/Shrink. You'll also want to set the
CanShrink to 'yes', as you (probably) want that textbox to close back up if
it doesn't need the extra room.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Paul Kraemer]

Hi Jeff,

I do have two other textboxes to the right of (and top aligned with) the
textbox that I want to be able to grow. These other textboxes will never
contain enough text to *need* a second line, but if I set Can Grow/Can Shrink
= Yes for these textboxes, will they follow along with the other textbox that
will actually need to grow/shrink at times?

Thank you for your help,
Paul

 

[Jeff Boyce]

Paul

I'm not sure ... check it out and post back!

Or another approach would be to 'nudge' your Grow/Shrink textbox slightly
higher (i.e., don't keep their tops aligned).

Regards

Jeff Boyce
Microsoft Office/Access MVP