Setting detail.height in VBScript

[KeithWilliams]

Hi,

I am trying to change the height of my form's detail section programmatically. As a simple example, why doesn't the following work:

MsgBox (Me.Detail.Height)
Me.Detail.Height = 7000
MsgBox (Me.Detail.Height)

When I run this script the two message boxes both show 8385.

Yours in frustration!
Keith.

 

[KeithWilliams]

Oops, spoke too soon! The code was failing because I was trying to reduce the size of the detail band too small to accommodate a label. Even though I had hidden the label programmatically, Access still seems to insist I leave room for it!

Thanks.
Keith.

 

[KeithWilliams]

I should have known that! I stand corrected.

Thanks,
Keith.