Wrap text in access report column based on combo box

[Pat B]

I am designing a report that has about fifteen columns on legal size paper.
Sometimes the results in a column are longer than others and need more than
one line to display the data. The data is based on a combo box which pulls
selections from checkboxes based on a table. Any way I can wrap this
text--as it is now cutting it off and there is no "can grow" listing in the
properties?

 

[Arvin Meyer MVP]

Combo boxes are limited to displaying a single line.

 

[June7]

Your are designing a report or a form? There are CanGrow and CanShrink
properties for text box on the Format tab, almost at the end of listings.
Cannot wrap text in listboxes or comboboxes.

 

[John W. Vinson]

I am designing a report that has about fifteen columns on legal size paper.
Sometimes the results in a column are longer than others and need more than
one line to display the data. The data is based on a combo box which pulls
selections from checkboxes based on a table. Any way I can wrap this
text--as it is now cutting it off and there is no "can grow" listing in the
properties?

If you're putting a COMBO BOX on a report... don't. As noted elsethread combo
boxes can't wrap; textboxes can. You can base your report on a Query joining
to the lookup tables currently displayed in combos, and set the Can Grow
properties of the textboxes bound to these fields.

 

[Pat B]

Thanks! This worked great by basing the report on the field properties in
the query. Since I have lines between each column, is there anyway to make
these grow with the textwrap? Probably not....but I'm trying to figure how I
can make it look better and differentiate the columns. Thanks again for such
a quick response...it saved me hours at work today.

 

[John W. Vinson]

Thanks! This worked great by basing the report on the field properties in
the query. Since I have lines between each column, is there anyway to make
these grow with the textwrap? Probably not....but I'm trying to figure how I
can make it look better and differentiate the columns. Thanks again for such
a quick response...it saved me hours at work today.

Not sure what you're asking here! Do you have a Datasheet on the report or
textboxes? If textboxes you can make them any size you want, and they should
grow vertically; I can't imagine how you would get a consistant display if
they could grow horizontally, and to my knowledge they can't be made to do so.

 

[Pat B]

What I meant is I have page length lines between each column, since the info
is so close together. AFter using the "can grow" the vertical lines don't
grow with it--and therefore leave spaces that don't look very uniform. But
what I think will work is just to highlight alternate columns, and the text
info will then differentiate better than the column next to and I'll just
remove the border lines I've inserted. Thanks!

 

[John W. Vinson]

What I meant is I have page length lines between each column, since the info
is so close together. AFter using the "can grow" the vertical lines don't
grow with it--and therefore leave spaces that don't look very uniform. But
what I think will work is just to highlight alternate columns, and the text
info will then differentiate better than the column next to and I'll just
remove the border lines I've inserted. Thanks!

<blush> That was clear on rereading your post. I've seen code somewhere to
make vertical lines grow but I'd say it's not worth the hassle.