Re: making a footer visible=false in a report
- From: "david epsom dot com dot au" <david@epsomdotcomdotau>
- Date: Wed, 23 Nov 2005 08:53:37 +1100
Don't try to figure it out: just try 1,2,3,4,5,6,
until you find which one is correct, or, better
use
me.printsection = false
(david)
"kaosyeti@xxxxxxxxxxx" <u15580@uwe> wrote in message
news:57b9ce82c635c@xxxxxx
>i can't get this working. in vba i tried to set visible to false in an if
> statement that looked like this:
> Private Sub GroupFooter1_Format(Cancel As Integer, FormatCount As Integer)
> If IsNull(Forms!formquerybuilder.Controls!cboxdepartment) = False Then
> Reports!rptcontactdata.Section(GroupFooter1).Visible = False
>
> End If
>
> instead of 'groupfooter1' i tried using 'section(1)', i tried using
> 'saleperson footer' which is the name of the group that corresponds to
> that
> section. i just can't figure this one.
>
> the report is divided into 3rds, top is 'department 1', middle is
> 'department 2' and bottom is the combined total. my statement is supposed
> to
>
> hide the total (bottom 3rd) when the user selects only one department to
> run
> the report off of (rather than the usual 'null' that will force the report
> to
>
> do both departments w/total).
>
> what have i got wrong?
>
> Greg
>
> --
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/200511/1
.
- References:
- making a footer visible=false in a report
- From: kaosyeti@xxxxxxxxxxx
- making a footer visible=false in a report
- Prev by Date: Re: Advice on upgrading 97 runtime app to 2003
- Next by Date: Re: dCOUNT DATE
- Previous by thread: making a footer visible=false in a report
- Next by thread: Re: making a footer visible=false in a report
- Index(es):
Relevant Pages
|
