By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,312 Members | 1,248 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,312 IT Pros & Developers. It's quick & easy.

Group Footer

P: 1
I have sumation in my group footer that I would like to hide when the sumation = zero. I am relatively new to MS access and my current attempt involved the onformat and the following expression:

=(Section(8).[DisplayWhen] Like [Sum Of 2004 ACTUAL]>o

I have also tried making the footer invisible then using the onformat expression:

=([Sum Of 2004 ACTUAL]>)=Section(8).[Visible])

needless to say neither one of these ideas. Does anyone have any thoughts?
I feel like I am going about this the wrong way.
Jun 5 '07 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 10K+
P: 14,534
You need to actually build vba code in the onformat event of the footer.

1. The Group Footer has a name lets call it grpFooter1
2. I don't know the name of the textbox which displays the 0 value so lets call it summary

Your code then should look something like this.

Expand|Select|Wrap|Line Numbers
  2. Private Sub grpFooter1_OnFormat()
  3.     If Me!summary = 0 Then
  4.         Me.grpFooter1.Visible = False
  5.     Else
  6.         Me.grpFooter1.Visible = True
  7.     End If
  8. End Sub
Jun 6 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.