Results 1 to 2 of 2
2013-03-22, 11:36 #1
- Join Date
- Sep 2001
- Montreal, Quebec, Canada
- Thanked 1 Time in 1 Post
Formatting Reports Like Table View (Access 2007)
Having created a tabular report from a Table, using the Report Wizard, is there a way of formatting it so it looks like a print from the table with gridlines and shading on alternate detail lines?David P - The Truth Is In Redmond
2013-04-18, 11:40 #2
- Join Date
- Mar 2013
- Thanked 0 Times in 0 Posts
Lots of formatting
Make sure all text boxes fit right next to each other in the detail section; no empty space anywhere across the width.
Make sure you have dark/black borders on all text boxes.
Make sure the height of the detail section is exactly the height of the text boxes, which all must be the same height and aligned with each other "to the top"
Make the text boxes fill as "transparent"
Turn on alternate row color in the detail section of the report.
That should about do it. It's at least a good start to making the output look like a datasheet view.
You might try putting a subreport into the detail section, with the subreport being a datasheet view of a query or table. I'd have to fiddle with that to see if the idea works, though.