Formatting Reports Like Table View (Access 2007)

Topic

New Reply

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?

Reply | Quote

Replies

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?

I’m not sure what you are up to, but try these things:

—————–
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.

Reply | Quote