How can i change the background in a Report Footer.

Clive Beaton
Clive Beaton used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2016

Commented:
Hi,

So it's not Back Color of the footer?

Regards
Jim Dettman (EE MVE)President / Owner
Most Valuable Expert 2017
Most Valuable Expert 2012

Commented:
The back color is currently set to what?

Should be #FFFFFF for white.

Jim.
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and Programming
Top Expert 2015

Commented:
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)
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Access Developer
Commented:
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.
Jim Dettman (EE MVE)President / Owner
Most Valuable Expert 2017
Most Valuable Expert 2012

Commented:
Glad to hear you figured it out.

Make sure you select your own last comment as answer.

Jim.
Clive BeatonAccess Developer

Author

Commented:
I accidentally found the solution.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial