defining rows on report

[tag141]

I have been trying to do this for ages and prefer to find a solution before asking but it's got me stumped good and proper. I've got the basics from the Northwind database looking up the 'customer labels' report. This is a report that shows all the customers, with addresses, in three columns. That's helped me get so far. The problem that still exists is that I want the first three addresses in my first column, the next three addresses in the second column, next three in the third column etc so that I can have text, full page width, underneath the columns. Access seems to like putting data full page length. There doesn't seem anyway to set the size of the rows.

Is anyone able to shed some light on my problem and make say 10 rows before it starts the next column.

TIA

 

[dhookom]

Do you have a good reason for displaying down then across rather than across then down? Do you always have 9 labels (3x3)?

It is possible to present like down then across when your report is actually set to across then down. This involves creating/calculating a sorting column in your record source.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[tag141]

The reason for going down then across is due to the fact that I want the user to check various boxes on the form. These will place a heading on the report (in the detail area). Some of these headings will have an associated list that need to be displayed. ie They might chose Union Jack, on the form Union Jack will be a heading and I would like it to display 'red, white,blue' underneath. I would like the form to printed on A5. If the user checks several boxes on the form, I need to print them. (I actually hope to have a photo of what I mean soon)
It was easy to change across then down to down then across in the page setup on the customer labels report. The space I have to work with is only 10 lines in height.

 

[dhookom]

I'm not sure I understand:
[li] "a heading...in the detail area"[/li],
[li]list associated with a heading[/li]
[li]something printed on a "form" [/li]
[li]'red, white,blue' are values that don't mean much without some understanding of tables and relationships[/li]
[li]check boxes ... print them[/li]
[li]space I have to work with[/li]

You should describe (fairly thoroughly) one issue and ask a specific question.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]