Multiple header lines

[vavs]

I have a report that has approximately 15 columns. I want to show 8 columns in one row and 7 columns in the second row for each record. I have just started playing with the report function in Access and it is working well up to this point. Am I better off putting labels and fields into the detail section and laying it out the way I want to?

Also, is there an autosize function for a field? I have a comment field that can vary widely in regards to the number of characters. What I would like to do is have the report wrap the text much like you can do in Excel.

 

[SydneyGeek]

Try laying the fields and labels out as you suggest.

Make the Comment field the last field in the sequence, with nothing below it.
Set that field's Can Grow property to Yes; do the same for the Detail section.

Denis