Changing Height of Section

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report indicating the number of students involved in activities by
high school. The same constants keep repeating by school. I want to
suppress that line when all the schools offer the same activity such as
football.

Everything works except the height of the section. Here is the example code
I have! Does anyone know what I have got to change to get the height smaller.

If bytCnt = 255 Then
Reports!rptTHarrisA.GroupHeader1.HEIGHT = 0.5
LabelA.Visible = True
LabelB.Visible = True
LabelC.Visible = True
LabelD.Visible = True
LabelE.Visible = True
bytCnt = 0
Else
Reports!rptTHarrisA.GroupHeader1.HEIGHT = 0.25
LabelA.Visible = False
LabelB.Visible = False
LabelC.Visible = False
LabelD.Visible = False
LabelE.Visible = False
End If

Any help is appreciated. Thanks Granny.
GroupHeader0 is the school District, GroupHeader1 is the high school break.
 
Check Help for the CanShrink property; you need it set both on the Controls
and the Section. If you shrink away an entire line, the Section will shrink
to match.

Larry Linson
Microsoft Access MVP
 
Granny;
You must declare the Group-Header Twice. There is no need to use
Grow or Shrink or setting your Labels to false.

Have two group Breaks on each high school, then add the following
code.

If bytCnt = 255 Then
Reports!rptTHarrisA.GroupHeader2.Visible = True
Else
Reports!rptTHarrisA.GroupHeader2.Visible = False
End If

I am sure this will work I do it all the time. By the way I am also a
teacher (Computers in Business in Indiana) and a football coach.

God Bless and Good Luck

Coach Barber
 
Back
Top