Solved

Placing a border around a header, detail and footer on an Access report

Posted on 2014-07-29
3
1,448 Views
Last Modified: 2014-07-30
Is there a format control where I can paint a border around the group header, detail and group footer as opposed to having a separate border around each object?

Thanks

Glen
0
Comment
Question by:GPSPOW
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 92

Accepted Solution

by:
Patrick Matthews earned 500 total points
ID: 40228176
No.  Controls are tied to a single report section.  You'll need to draw part of the border in each section as appropriate.
0
 

Author Closing Comment

by:GPSPOW
ID: 40228190
That's what I thought.

Thanks

glen
0
 
LVL 57
ID: 40228831
Just to add on, there are two things you might do:

1. On the OnPage event, you can draw borders.   Here I would hold the top property of each section in variables as I worked down the page.  Then in the OnPage event you could draw the lines to border everything.

2. You can at the start of the page, draw a border around the entire page.  Then in the sections, draw a horizontal line as needed.   You'd end up with sections then on your page.

Jim.
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question