Dynamically change height of Group header

[dkaplan]

I'm trying to dynamically change the height of a group header on an Access report, depending on conditions.

The group header shrinks as expected, but when conditions change it does not expand.

My code is below:

Private Sub GroupHeader0_Format(Cancel As Integer, FormatCount As Integer)
If Nz(Me!textBoxWithAvalue, 0) = 1 Then
Me.Label89.Visible = True
Me.GroupHeader0.Height = 0.21
Me.Label89.Height = 0.2082
Me.tbHeader.Height = 0.2083

Else:
Me.Label89.Visible = False
Me.GroupHeader0.Height = 0.01
Me.Label89.Height = 0.01
Me.tbHeader.Height = 0.01

End If

End Sub

 

[dhookom]

Do you understand that height is typically measured in twips. A twip is 1/1440 of an inch (very tiny).

Duane
Hook'D on Access
MS Access MVP

 

[dkaplan]

Actually I did NOT know that. I have to confess I though it was inches. This explains the behavior I was seeing, and I have been able to adjust accordingly.

Thanks, dhookom.