Manipulate Label Height

[dynamictiger]

Is it possible to manipulate a label height on a report at Run Time?

My report adds an extra page in some cases when the label is sized correctly but hidden, I thought if I shrunk it I could avoid this problem - which works, however, I cannot seem to manipulate it in code to bring it back to full size.

 

[scriverb]

When using VBA code to manipulate the height of controls or labels you have to set the .height property in TWIPS. TWIPS are 1/1440" in size. You will have to make the determination on when to do it but it seems you have that already figured out.
this changes it to 1.2":
me![labelName].height = 720

This changes it to a thin line with no height:
me![LabelName].Height = 0


Good luck

Bob Scriver