Footer question

[Ray1127]

I have an Access 2000 Report with a Group footer. There is a requirement on 1 of the values of the Group that totals be displayed but not for the rest of the groups

This is the code:

If Me.txtType = "Drugs" Then
Me.GroupFooter1.Height = 0.3
Me.Text85.Visible = True
Me.Text87.Visible = True
Me.Line89.Visible = True
Me.Text85.Top = 0.0833
Me.Text87.Top = 0.0833
Me.txtType.Top = 0.0833
Me.Text85.Height = 0.2083
Me.Text87.Height = 0.2083
Me.txtType.Height = 0.2083
Me.Line89.Top = 0.0417
Me.Line93.Top = 0.2917
Else
Me.GroupFooter1.Height = 0.1
Me.Text85.Visible = False
Me.Text87.Visible = False
Me.Line89.Visible = False
Me.Text85.Height = 0
Me.Text87.Height = 0
Me.txtType.Height = 0
Me.Text85.Top = 0
Me.Text87.Top = 0
Me.txtType.Top = 0
Me.Line93.Top = 0.0417
Me.Line89.Top = 0
End If

The problem is for the type Drugs the data is not shown as it should be. Because the Group Height is set to .1 not .3. I'm assuming that the Group Height is set universally and can't be changed based on the value of the group. Anybody have an idea how I can accomplish this requirement? I'm stuck.

 

[dhookom]

How about simple code that hides the group section:

  Cancel = Me.txtType <> "Drugs"

Duane
Hook'D on Access
MS Access MVP

 

[Ray1127]

I would've never thought of that. I'll try it and let you know.

 

[Ray1127]

That worked perfectly. Thanks again.