Format Event 1

[Freckles]

How do I cancel a footer when a control equels something specific?? From what I have read, I need to do this in the "on format" property. Here goes:

When [control] = "special" cancel format, if it does not = "special" then format.

Now how do I say the expression???? : Deb Koplen
deb.koplen@verizon.com

A person can stand almost anything except a succession of ordinary days.

 

[JoeMiller]

In the OnFormat event of the section you are trying to hide place the code like so replacing the names with your own:

If Control = "special" Then
FooterName.Visible = False
End If

Joe Miller
joe.miller@flotech.net

 

[Freckles]

Somewhere I missed something

If Control = "special" Then
FooterName.Visible = False
End If

What is happening is that footer section is not visible throughout the report no matter which unique control I refer to. So, what do I use for the "footername"? Do I use the one that appears on the module "groupfooter3" or do I use the default name shown in the design of my report "text180" or do I assign a particular name to it.
: Deb Koplen
deb.koplen@verizon.com

A person can stand almost anything except a succession of ordinary days.

 

[JoeMiller]

FooterName = the section you are trying to hide, if groupfooter3 is the section you wish to disappear then it will disappear if you set groupfooter3.Visible = False

Control = the name of the control that has the special value within FooterName, if text180 is the control that will house the value "special"

So if we use those names that you gave:

If Text180 = "special" Then
GroupFooter3.Visible = False
End If

Hope that clears things up! Joe Miller
joe.miller@flotech.net

 

[MichaelRed]

If Text180 = "special" Then
GroupFooter3.Visible = False
Else
GroupFooter3.Visible = True
End If


MichaelRed
redmsp@erols.com

There is never time to do it right but there is always time to do it over

 

[JoeMiller]

Oh my stupidness, I'm sorry Deb no wonder you were having problems. Listen to Michael he fixed my foible. Thanks Mike!

Joe Miller
joe.miller@flotech.net

 

[Freckles]

THANKS -- that did it!

:-X :-X :-X :-X :-X :-X :-X : Deb Koplen
deb.koplen@verizon.com

A person can stand almost anything except a succession of ordinary days.