[MS_AccessPros] Access Report Format event question

 

Hello all,

I have a report that have several headers named

GroupHeader1

GroupHeader2

I want to hide the headers if there is no data for them. I have the following code in both OnFormat events, below. It works great and then it does not. But if we just open the VBA window to the events. and then close the VBA window it works.

When it does not work it shows the headers. When it works the headers are NOT visible.

Is there something missing from the code or something else?

Thank You

Jim Wagner

Private Sub GroupHeader1_Format(Cancel As Integer, FormatCount As Integer)
Cancel = IsNull(Me!Subdept)

End Sub

Private Sub GroupHeader2_Format(Cancel As Integer, FormatCount As Integer)
Cancel = IsNull(Me!Subdept2)
End Sub

__._,_.___

---

Posted by: luvmymelody@yahoo.com

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (1)

---

Upgrade your account with the latest Yahoo Mail app

Get organized with the fast and easy-to-use Yahoo Mail app. Upgrade today!

---

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___