Stop Details From Being Printed

[crhodus]

How can I prevent my labels and textboxes from being printed on my report if there is no data to display for the fields located in my detail section? My 2 group headers will have data, but sometimes the detail section will not.

Thanks!

 

[ed333]

Maybe in the OnFormat event for the Detail Section, you could set the IsVisible property to False after testing whether or not data was present. Hope this helps,

Ed

 

[crhodus]

I tried using the following code in the "On Format" and "On Print" property for the Detail section, but it doesn't seem to work.

If Me.update_notes = "" Or Me.update_notes = Null Then
Me.lblProjUpdates.Visible = False
Me.lblDate.Visible = False
Me.update_notes.visible = False
End If


If I remove the If Then statement and use the following code, the text boxes and labels disappear:
Me.lblProjUpdates.Visible = False
Me.lblDate.Visible = False
Me.update_notes.visible = False

For Some reason, I can't get vb to recognize that there is no value for update_notes.

Any other ideas or suggestions?

Thanks!

 

[crhodus]

Thanks! The IsNull(Me.update_notes) did the trick!