Clarification?

[NUWildcat]

In a previous post someone had mentioned that it might be possible if a report was based on a query, to put an expression into it which would make the field become invisible if it was null. There are certain fields in my report which for some scenarios end up being empty and so I am trying to find a way to have them dissapear so it doesnt look like there are empty holes in my report. Is this possible or is there some way to change the color of a label's characters based on a null value to make it the same as the background, thus in essence dissapearing?
Thanks in advance!

 

[Rich]

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)

If Me.AmntPd <= 0 Then
Me![Text37].ForeColor = 16777215
Me.Text60.Visible = True
Else
Me.Text60.Visible = False
Me![Text37].ForeColor = 0
End If
If Me![AmountPaid] = "0" Then
Me![txtDate].ForeColor = 16777215
Else
Me![txtDate].ForeColor = 0
End If
If Me![AmountPaid] = "0" Then
Me![Text56].ForeColor = 0
Else
Me![Text56].ForeColor = 16777215
End If
If IsNull(Me.txtEnd) Then
Me.txtEnd.Visible = False
Else
Me.txtEnd.Visible = True
End If
If Me.PaymentType = "BalanceTransfer" Then
Me.Label69.Visible = False
Else
Me.Label69.Visible = True
End If

Me.Text52 = MyName
End Sub

 

[NUWildcat]

Thank you, that worked perfectly!