Multi-Column Report (1 Viewer)
- Thread starter jsic1210
- Start date
EternalMyrtle
I'm still alive
- Local time
- Today, 10:16
- Joined
- May 10, 2013
- Messages
- 533
Can you post your report with dummy data?
I do this all the time. Here is how I do it:
Depending on the complexity of my report, I use the group function to create a separate header bar for all of my headings. I remove the one I want centered from the layout and put it above the others. Then I make the text box big enough to span the whole width of the columns. Then use the center text option in Home>Fonts. It works for me but there are probably many ways to do this.
Hope this helps.
I do this all the time. Here is how I do it:
Depending on the complexity of my report, I use the group function to create a separate header bar for all of my headings. I remove the one I want centered from the layout and put it above the others. Then I make the text box big enough to span the whole width of the columns. Then use the center text option in Home>Fonts. It works for me but there are probably many ways to do this.
Hope this helps.
EternalMyrtle,
Sorry for the delay, but I put this project aside for a while. I'm able to span the report header across multiple columns, but not group headers. Are you saying you create a group header using an expression as opposed to a specific field?
Thanks,
Jeff
Sorry for the delay, but I put this project aside for a while. I'm able to span the report header across multiple columns, but not group headers. Are you saying you create a group header using an expression as opposed to a specific field?
Thanks,
Jeff
EternalMyrtle
I'm still alive
- Local time
- Today, 10:16
- Joined
- May 10, 2013
- Messages
- 533
Here is a simplified example. Is this similar to what you are attempting to do? If not, perhaps you can post your report and table so I can see.
Hope this helps.
Hope this helps.
No, I have multiple columns in the report (Page Setup > Columns: Number of Columns: 2, Across, then down). I'm using it as a sub-report, so that's why it's Across then down.
I've attached a dummy database. The group header is City, so I want the city name to span across multiple columns, but as you can see in Print Preview, the city names get cut off going into the second column.
I've attached a dummy database. The group header is City, so I want the city name to span across multiple columns, but as you can see in Print Preview, the city names get cut off going into the second column.
Last edited:
EternalMyrtle
I'm still alive
- Local time
- Today, 10:16
- Joined
- May 10, 2013
- Messages
- 533
Yes, I get it now. The problem is with the multiple column layout in page setup for printing. I thought that by "column", you were simply referring to the report controls as "columns" since they are technically columns in your table.
Unfortunately, I have tried using the multiple column layout in page setup and have not had much success getting it to look the way I'd like it to look so I cannot help you.
Sorry!
Unfortunately, I have tried using the multiple column layout in page setup and have not had much success getting it to look the way I'd like it to look so I cannot help you.
Sorry!
No problem, I had that feeling. Thanks for looking into it!
Another problem I'm having with that report is that each group is printing on a separate page. Do you know if there's a way to fix this? I have Force New Page set to No.
Another problem I'm having with that report is that each group is printing on a separate page. Do you know if there's a way to fix this? I have Force New Page set to No.
EternalMyrtle
I'm still alive
- Local time
- Today, 10:16
- Joined
- May 10, 2013
- Messages
- 533
Perhaps this will help: http://office.microsoft.com/en-us/access-help/multiple-column-reports-HA001156534.aspx
