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
Subscribe to our Windows Secrets Newsletter - It's Free!
Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!
+ Get this BONUS — free!
Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!
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.