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

Bruce,

Sounds good, thanks for the help.

Brad

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

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.

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
This message was scanned by ESVA and is believed to be clean.
Click here to report this message as spam. 
http://h0stname/cgi-bin/learn-msg.cgi?id=947E128CB0.C6C7C