how do I get the columns in my access report not to overlap?

[Guest]

I am creating a report with approximately 50 columns. When I use the wizard
to create a tabular report it sets it up with all the columns overlapping so
the data is not legible. I have tried highlighting the row of column
headings and increasing spacing, which works fine in the first two pages, but
then bunches everything up on the third page instead of expanding to more
pages. What do I do?

 

[Jeff Boyce]

Ian

You don't indicate what type of data you're displaying in those "50
columns". Is there a chance that the data could be displayed (in a report)
in a different way? What kind of information needs 50 columns to show it
all?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

I am really trying to print something laid out exactly like the query I am
working from, but I can't get the row headings to repeat on every page by
printing from the query. Maybe I am trying to do the wrong thing?

 

[Duane Hookom]

I can't imagine any page size that would display 50 columns unless they were
fairly small values. You might want to consider pushing the query to Excel
where you might be more comfortable creating headings and printing to fit.