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 -
Quote:
Originally Posted by 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!
