?
Solved

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

Posted on 2014-07-29
3
Medium Priority
?
1,535 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 93

Accepted Solution

by:
Patrick Matthews earned 2000 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 58
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

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

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

It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Suggested Courses

770 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