Hiding a Report Footer on Report Open

[Lewe22]

Upon opening a Report i have created, i need to hide the report footer when 2 text boxes contain the same numeric value.

I am hoping something will be possible using the Height property of the page footer, though i have my reservations about whether this will work when the footer contains data.

The only other way i can think of would be to make all fields contained in the footer Invisible, though this will

Can anyone supply me some VB they think might help?
Does anyone have any ideas?

Thanks!

[sierra7]

In the 'On Format' event of the Footer section of your report write the code shown in line 3;-

Private Sub PageFooterSection_Format(Cancel As Integer, FormatCount As Integer)
 
If Me!Text2 = Me!Text0 Then Cancel = True
 
End Sub

where Text0 and Text2 are the names of the two text boxes being evaluated.

S7

[Minion]

I'm taking it you're talking about two of the text boxes on the report. If they are different boxes the code will be different, but for now put the following code in the form's on open event:

with me
   if .Text1 = .Text2 then
      .PageFooterSection.Visible = False
   end if
end with
 

This should hide the footer of the report if the two boxes are equal.

Hope this helps.

- Minion -

Upon opening a Report i have created, i need to hide the report footer when 2 text boxes contain the same numeric value.

I am hoping something will be possible using the Height property of the page footer, though i have my reservations about whether this will work when the footer contains data.

The only other way i can think of would be to make all fields contained in the footer Invisible, though this will

Can anyone supply me some VB they think might help?
Does anyone have any ideas?

Thanks!

[Lewe22]

Thanks Sierra7. Your code worked great!