Multiple header lines

vavs

Well-known Member
Joined
Jul 2, 2004
Messages
512
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.
 

Some videos you may like

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

SydneyGeek

MrExcel MVP
Joined
Aug 5, 2003
Messages
12,251
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
 

Watch MrExcel Video

Forum statistics

Threads
1,109,085
Messages
5,526,762
Members
409,720
Latest member
Antwain

This Week's Hot Topics

Top