Solved

How can i change the background in a Report Footer.

Posted on 2016-09-01
6
21 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
6 Comments
 
LVL 49

Expert Comment

by:Rgonzo1971
ID: 41779410
Hi,

So it's not Back Color of the footer?

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

Should be #FFFFFF for white.

Jim.
0
 
LVL 19
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
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 

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 57
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

895 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now