Hide Empty fields in a report

krberube

just beyond new
Local time
Today, 09:26
Joined
Jan 14, 2005
Messages
142
Hi All, I'm quite new to making advanced reports in MS Access and need some help. I have a field from a query called "RVIModel", that may or may not contain data. If its empty, I want to hide The data field and the Label.

I have seen Posts that seem to cover this but I can't make them work. here is one I ahave seen:

If IsNull(Me.YourField) Then
Me.YourField_lbl.Visible = False
Else
Me.YourField_lbl.Visible = True
End If

If this is correct maybe I'm placing it in the wron spot.
Any help would be greatly appreciated.

Thanks!!
 
krberube said:
If IsNull(Me.YourField) Then
Me.YourField_lbl.Visible = False
Else
Me.YourField_lbl.Visible = True
End If

try this better:

Me.YourField_lbl.Visible = Me.YourField_lbl.HasData
 
Thanks Chile19!
 
Hide Empty Fields In A Report

Me.YourField_lbl.Visible = Me.YourField_lbl.HasData

Guys, should this work for a bound field from a form?
 
Last edited:

Users who are viewing this thread

Back
Top Bottom