Splitting titles into additional rows

[Jack Sheet]

Hi all
Access 97

I am trying to produce a report in tabular format, with field names in the
report header.
Some of the field names are quite long, comprising several words. Where the
field name is longer than the width of the column assigned to the field I
want to "wrap" the text so that the depth of the title row increases to
accommodate the field name.

How do I achieve this, please?

Thanks

 

[Albert D.Kallal]

Just set the "can grow" properity of the text box, and it will warp and grow
for you....

 

[John Spencer]

Since the field names are probably label controls, you will have to manually
resize the label controls by clicking on them and then grabbing one of the
handles (little squares) and pulling down until the text fits.

If you have managed to get the field names into textbox controls vice label
controls, you can do as Albert Kallal suggested elsewhere in this thread.

 

[Jack Sheet]

Thanks to both Albert and John. Both responses helpful to me