Is it one of those things where the code knows you’re watching so it doesn’t misbehave?
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Thursday, April 28, 2016 12:04 PM
To: Access Professionals Yahoo Group
Subject: RE: [MS_AccessPros] Access Report Format event question
Are you viewing in Report View or Print Preview? Code doesn't run in Report View.
Duane
To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Thu, 28 Apr 2016 11:20:48 -0700
Subject: [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(Cance! l As Integer, FormatCount As Integer)
Cancel = IsNull(Me!Subdept2)
End Sub
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
Posted by: Liz Ravenwood <Liz_Ravenwood@beaerospace.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (3) |
Tidak ada komentar:
Posting Komentar