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!!
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!!