Murray Brown
asked on
Access - Create borders in a report
Hi Anders,
the easiest way will be using the grid control, and specifying grid lines.What grid control are you referring to? I haven't seen any new controls in Access, but may have missed it.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks very much. Horizontal lines was a great way to handle this. Access clearly doesn't format like Excel so that was close enoough
@Scott: Sorry, I meant layout grid, not grid control. Here is an example using the layout grid, and grid lines to "border" up the report. I have not found a way to make the vertical lines between the last detail, and the summary.
Gridline-Demo.zip
Gridline-Demo.zip
The only potential issue is that I am not sure it will work so well with the whitespace you have in your report, between the summary line and the footer. Alternatively, the report has a "Line" method, you can use from the format event, to draw lines. It is rather complicated, and requires you do work alot on the coordinates of controls. I don't have an example handy, but if you want to go that route, perhaps I can find an old project.