Solved

How can i change the background in a Report Footer.

Posted on 2016-09-01
6
25 Views
Last Modified: 2016-09-09
I have a report which provides some totals in the report footer.  When I print it, the footer has a grey background.  How can I fix this?  I've tried every property change I can think of.  I've been using Access since before the Rolling Stones heard of it, so it might be old age, but it's not a newbie problem.

Thanks in advance,

Clive

Screenshot attached.
Capture.JPG
0
Comment
Question by:CRB1609
[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
6 Comments
 
LVL 51

Expert Comment

by:Rgonzo1971
ID: 41779410
Hi,

So it's not Back Color of the footer?

Regards
0
 
LVL 58
ID: 41779461
The back color is currently set to what?

Should be #FFFFFF for white.

Jim.
0
 
LVL 21
ID: 41779985
adding on to Jim's comment ...

1. turn on the property sheet if it is not showing (Alt-Enter)
2. click on the footer section bar or in an area of the footer that does not contain a control to select the footer
3. Back color is on the Format tab -- click in that property
4. Click on the Builder button ... to pick from a list of absolute colors
   (clicking the drop-down arrow shows theme colors which may change if the theme is changed)
0
Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

 

Accepted Solution

by:
CRB1609 earned 0 total points
ID: 41780815
Thanks for your responses.

It's not the back colour of the footer which is set to #FFFFFF

I discovered by accidient that it occurs at the top of the last page where there are no detail lines on the last page, only the report footer.  I changed the the lenght of the page header and the problem went away.  It might be a bug in Access, otherwise it would be good to fix it.

Note that it's the page header/footer in the subreport.
0
 
LVL 58
ID: 41780823
Glad to hear you figured it out.

Make sure you select your own last comment as answer.

Jim.
0
 

Author Closing Comment

by:CRB1609
ID: 41791017
I accidentally found the solution.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
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 …

734 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