Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

How can i change the background in a Report Footer.

Posted on 2016-09-01
6
Medium Priority
?
31 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 53

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 22
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
Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

 

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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Suggested Courses

916 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