Hide Text Box On A Report

[all7holly]

Hello,

How do I hide a single text box on a report if there is no data? The label is called “LableBillingWeeks” and the control source is called “BillingWeeks”. Any thoughts?

 

[Aronvitki]

Set the Can Shrink property to Yes. It'll disappear if the text box has a null value.

 

[vbaInet]

Note that if the label is aligned horizontally with the control (i.e. is to the left of the control), it will not shrink.

 

[Aronvitki]

How is the layout configured? Can you give a screenshot of it?

 

[all7holly]

I have already set it to shrink. I need to have the label (BillingWeeksLable) show when there is data.

 

[vbaInet]

The label will not shrink at all. It will always be visible. Labels don't have a Shrink property.

 

[Aronvitki]

The label itself doesn't have a Shrink property, but you could set the visible property in VBA to whether or not the text box has a null value. In the report's On Current event, add:

Me.LableBillingWeeks.Visible = IsNull(Me.BillingWeeks)

That should take care of the label.

 

[all7holly]

Prefect thank you!