Solved

How can i change the background in a Report Footer.

Posted on 2016-09-01
6
20 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 48

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
Free Gift Card with Acronis Backup Purchase!

Backup any data in any location: local and remote systems, physical and virtual servers, private and public clouds, Macs and PCs, tablets and mobile devices, & more! For limited time only, buy any Acronis backup products and get a FREE Amazon/Best Buy gift card worth up to $200!

 

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

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

746 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

9 Experts available now in Live!

Get 1:1 Help Now