General discussion

Locked

Snaking Columns

By brannuml ·
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

This conversation is currently closed to new comments.

6 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Snaking Columns

by DKlippert In reply to Snaking Columns

If it's Word, select the field and go to Format>Columns.

Collapse -

Snaking Columns

by brannuml In reply to Snaking Columns

Poster rated this answer

Collapse -

Snaking Columns

by brannuml In reply to Snaking Columns

Sorry I forgot to add that this is an Access 2000 report.

Thanks
Laura

Collapse -

Snaking Columns

by DKlippert In reply to Snaking Columns

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."

Collapse -

Snaking Columns

by brannuml In reply to Snaking Columns

Thanks you are a lifesaver. I can't believe it was that easy!!

Laura

Collapse -

Snaking Columns

by brannuml In reply to Snaking Columns

This question was closed by the author

Back to Software Forum
6 total posts (Page 1 of 1)  

Related Discussions

Related Forums