Label Move Function on Report Print Event

[daallie]

I am working on a report and do not want a label to appear on certain conditions:

If Not Len(ExtendedInfo) > 0 Then
Me!Label34.Visible = False
Me!Label34.Top = 0
End If


The visible part works but to remove the white space I need to move it out of the way.

When this runs I get:

Run-time error '2101':
The setting you entered isn't valid for this property.


What is the proper way to do this

[Seth Schrock]

Where do you have this code? On which line do you get your error?

[daallie]

It on a Section Event - On Print

The error is on the line: Me!Label34.Top = 0

If Not Len(ExtendedInfo) > 0 Then
Me!Label34.Visible = False
Me!Label34.Top = 0
End If

[Seth Schrock]

Try it in the Detail On Format event.

[daallie]

On Format event works, it is moving the label but the section is not shrinking and it is configured with Can Shrink = Yes.

Is there a way to force to the Section to reset its height?

[Seth Schrock]

Are you sure that there isn't any other control that is stopping the section from shrinking?

[twinnyfo]

Make the height of the control to 0, with the CanGrow set to true. It will look like a gray line on your report in design mode, but when it prints it will take up room when it needs it and will take up no room when it doesn't need it. This prevents you from needing any VBA behind that control.

[daallie]

I was able to force it to shrink down to the proper size.

Me.Detail.Height = 0
 

Thank you Seth for the help