making a footer visible=false in a report

[kaosyeti]

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!cboxdepartm ent) = False Then
Reports!rptcontactdata.Section(GroupFooter1).Visib le = 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/For...ccess/200511/1

[david epsom dot com dot au]

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)
"ka******@comcast.net" <u15580@uwe> wrote in message
news:57b9ce82c635c@uwe...

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!cboxdepartm ent) = False Then
Reports!rptcontactdata.Section(GroupFooter1).Visib le = 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/For...ccess/200511/1

[Ed Robichaud]

Some possible problems-
Is your form still open to "read" that cmb value when the report prints? Is
[cboxDepartment] a number field? If not, try:
If Me!cboxdepartment <> " " Then

If it's only a few [totals] controls in that footer, why not set their
Visible property rather than the entire section?
-Ed
"ka******@comcast.net" <u15580@uwe> wrote in message
news:57b9ce82c635c@uwe...

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!cboxdepartm ent) = False Then
Reports!rptcontactdata.Section(GroupFooter1).Visib le = 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/For...ccess/200511/1