My Access report is too wide all the columns are overlapping

[Guest]

I am trying to print a report that looks basically like a table, but will
repeat the row headers at the beginning of every page, much like you can
easily do in Excel. I don't want to have to export to Excel because the
people running the report are not that sophisticated. The problem is that
there are 50 columns in the report, and each should be about .75 inch wide,
but Access limits me to 22 inches. Does anyone have a suggestion?

Thanks,

Ian

 

[Duane Hookom]

Do you have paper that is more than 22" wide? How about 37.5" wide?

 

[Guest]

I could use wider paper, but it doesn't help. I want it to use multiple
pages, but it simply will not allow me to create a column more than 22" wide.

 

[Duane Hookom]

To be honest, it would take much less time for me to teach someone how to
print the Excel worksheet then it would to create a report.