Software

Ask something
Discussion Locked

Snaking Columns

0 helpful
6 replies

by brannuml

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Help I've done this before but I can't remember how. I have a report that only has one field. I want that field to wrap (snake) and create multiple columns on the page.

Thanks in advance
Laura

6 replies

by dklippert

From the Access Help file:
"Create a report.
Notes
When a multiple-column report is printed, the report header and footer and page header and footer span the full width of the report, so you can place controls anywhere in these sections in Design view.

When printed, the group header and footer and detail section of a multiple-column report span the width of one column. For example, if you want to print the data in two three-inch columns, place the controls within the width of one column; in other words, place the controls in the first three inches of these sections in Design view.
On the File menu, click Page Setup.

In the Page Setup dialog box, click the Columns tab.

Under Grid Settings, in the Number Of Columns box, type the number of columns you want on each page.

In the Row Spacing box, type the amount of vertical space you want between each record in the detail section.
Note If you left space between the last control in the detail section and the bottom edge of the detail section, you can leave Row Spacing set to 0.

In the Column Spacing box, type the amount of space you want between the columns.

Under Column Size, type the width you want for a column in the Width box; for example, 3 inches. You can set the height of the detail section by typing a number in the Height box or by adjusting the height of the section in Design view.

Under Column Layout, click the Down, Then Across option or the Across, Then Down option.

Click thePage tab.

Under Orientation, click Portrait or Landscape.

Click OK.
Notes

For information on starting each group in a new row or column, click .

The Products by Category report in the Northwind sample database displays data in multiple columns. To view this report, open the Northwind database in the Samples subfolder of your Office folder, and then open the Products by Category report in Design view."

This discussion is closed to new replies.