How to dispay multiple columns for a field?

[Guest]

I have a listbox in the header of a report. When there are too many rows to
list in a single column, I would like them to flow into adjacent columns --
like text in Word when newspaper-style columns are in effect. If the header
were limited to 3 rows of output, it would look like this:
_________________________
row1 row4 row7
row2 row5 row8
row3 row6 row9 ...
_________________________

Is there a control in Access that can do this? Or should I try embedding a
Word object in my report?

Thanks!

 

[Dirk Goldgar]

I have a listbox in the header of a report. When there are too many
rows to list in a single column, I would like them to flow into
adjacent columns -- like text in Word when newspaper-style columns
are in effect. If the header were limited to 3 rows of output, it
would look like this: _________________________
row1 row4 row7
row2 row5 row8
row3 row6 row9 ...
_________________________

Is there a control in Access that can do this? Or should I try
embedding a Word object in my report?

Maybe a multi-column subreport would serve your purpose.

 

[Guest]

Hi Dirk,

That was the first thing I tried. It was OK when i tested it in the Detail
section of a report, but it reverted to single-column when I put it in the
Report Header.

 

[Dirk Goldgar]

Hi Dirk,

That was the first thing I tried. It was OK when i tested it in the
Detail section of a report, but it reverted to single-column when I
put it in the Report Header.

You have to make sure that the subreport control on the main report is
wide enough to print all the columns. If you just drag it in and don't
resize it, it won't be.