Column Issues!

[digitalxni]

Afternoon!

I've currently got a simple report with one text box in it which is linked to a query that produces a list of names which is going to be a sub-report. So rather than it printing a long list I want to order it in columns. I know that I have to use page setup to change the column settings and I've tried so many different combinations but I just can't seem to get it to work!

Included is a screenshot of my current settings. The detail section of the report has a width of 2.5cm and the postcode textbox is 2cm wide.

Any ideas what I'm doing wrong?

 

[DCrake]

did you set this report up as a label report?

 

[digitalxni]

No idea so probably not! How do I do that?

 

[DCrake]

In the reports tab select new > Label Wizard > Next ....

 

[digitalxni]

I've just noticed that it works in print preview but not in report view and in print preview I only seem to be getting 4 postcodes to a page and therefore I'm getting multiple pages and the idea was to condense them all into less than a single page. I've tried messing with the column height and detail height but to no avail.