Link to home
Start Free TrialLog in
Avatar of Murray Brown
Murray BrownFlag for United Kingdom of Great Britain and Northern Ireland

asked on

Access - Create borders in a report

Hi

I have been asked to create borders in an Access report that is for in an invoice similar to that shown in the image below.
I am just looking for some suggestions on the best way to do this in Access.

Thanks

User generated image
Avatar of Anders Ebro (Microsoft MVP)
Anders Ebro (Microsoft MVP)
Flag of Denmark image

If access 2010 or newer, the easiest way will be using the grid control, and specifying grid lines.

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.
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
Avatar of Dale Fye
Dale Fye
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Murray Brown

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