[AccessD] Background Color for Entire Access Report Page

Charlotte Foust charlotte.foust at gmail.com
Sat May 5 10:31:28 CDT 2012


Any time you try to make Access reports behave like Word, you run into
roadblocks.  Fortunately, there are usually workarounds, but sometimes the
effort required is simply not worth it for the result achieved.

Charlotte Foust

On Sat, May 5, 2012 at 7:32 AM, Brad Marks <BradM at blackforestltd.com> wrote:

> Jim,
>
> Thanks for your ideas.
>
> I have been experimenting with a different approach that seems to work.  I
> used Microsoft Paint to create a simple jpg file that is colored light
> blue.  I then pointed the Access Report "Picture" property at this jpg
> file.  This seems to work in my initial tests, but I suppose that I may
> discover a downside in future tests.
>
> Brad
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com on behalf of Jim Dettman
> Sent: Sat 5/5/2012 9:18 AM
> To: 'Access Developers discussion and problem solving'
> Subject: Re: [AccessD] Background Color for Entire Access Report Page
>
> Brad,
>
>  In the OnPage event, draw a rectangle and fill it.  You'll need all the
> controls background set to transparent.
>
>  You can also address the entire page from one of the header events if you
> want. You just need .MoveLayout = False if your not doing anything in that
> band (ie. you have no page header but draw the rectangle in the page header
> OnFormat event).
>
> Jim.
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks
> Sent: Friday, May 04, 2012 10:00 PM
> To: Access Developers discussion and problem solving
> Subject: [AccessD] Background Color for Entire Access Report Page
>
> All,
>
> I would like to make the background of an entire report page light blue in
> color.
>
> I thought that this would be really easy to do.  I simply used a "fill"
> color for each of the sections of the report (Report Header, Page Header,
> Detail, Page Footer, Report Footer).
>
> My test report only has a few lines of data that fills about 1/3 of the
> page
> at the top.
>
> When I print the report, the top 1/3 of the page is blue, the very bottom
> of
> the report (the page footer) is blue, but there is a large area of the page
> that is still white.
>
> Is there a way to make the entire page blue?
>
> Thanks,
> Brad
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
>
>
> Website: http://www.databaseadvisors.com
>
>
>
> --
> This message has been scanned for viruses and
> dangerous content by MailScanner, and is
> believed to be clean.
>
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
>
>
> Website: http://www.databaseadvisors.com
>
>
>
>


More information about the AccessD mailing list