[AccessD] Is it Possible to Suppress Select Report Footers? (Access 2007)

Kovacs, Bruce bruce.kovacs at urs.com
Mon Jun 17 13:07:40 CDT 2013


I have used the following approach to hide a horizontal line [MyDetailLine] following the last record in the Detail section of a report.

I put a text box named [MyCounter], with a Record Source of =1, in the Detail section, and another text box named [MyTotal], with a Record Source of =Count([DocID]), in the applicable Group footer.  I added the following code to the Detail Format event:

    If Me![MyTotal] = Me![MyCounter] Then
        Me![MyDetailLine].Visible = False
    Else
        Me![MyDetailLine].Visible = True
    End If



Bruce Kovacs
URS Corporation
bruce.kovacs at urs.com


-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust
Sent: Saturday, June 08, 2013 12:01 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Is it Possible to Suppress Select Report Footers? (Access 2007)

You can create multiple groups on the same value, i.e., Order ID.  Create a second one without the dashed line and show/hide it as required.

Charlotte

On Fri, Jun 7, 2013 at 12:37 PM, Brad Marks <BradM at blackforestltd.com>wrote:

> All,
>
> I have a report that shows Order information by day.
>
> There is a "Group" on Day and a second "Group" on Order ID.
>
> Currently there is a thick solid line in the Day Footer to separate
> each day on the report.
>
> There is also a dashed line in the Order ID Footer to separate each
> order.
>
> Is there a way to suppress the Footer on the Order ID when there is a
> Day Footer generated?
>
> It looks a little goofy to have a dashed-line followed immediately by
> a solid line when there is a change in day.
>
> Thanks,
> Brad
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


This e-mail and any attachments contain URS Corporation confidential information that may be proprietary or privileged. If you receive this message in error or are not the intended recipient, you should not retain, distribute, disclose or use any of this information and you should destroy the e-mail and any attachments or copies.



More information about the AccessD mailing list