Hello

I have a report were there are multiple txtfields of different records in the detail section, and one label
what i want is that depending on the content of a textfield that the label is made invisible for that record the code i use is:
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If IsNull(Me.Opmerkingen) Then
Me.lblopmerking.Visible = False
End If
End Sub

But this will make the lblopmerkingen visible or invisible for all the records

Does anyone has an idea ?

Greeting Johan

If IsNull(Me.Opmerkingen) Then
Me.lblopmerking.Visible = False
Else
Me.lblopmerking.Visible = True
End If

Thanks rich

for your reply, but this didn't solve the problem

any other ideas

greeting Johan

Rich's solution should work.

Post a demo of your db.

Hello again

I tested it again and now it's working
I don't know what was wrong with the report but i repaird and compacted the Mdb and now it's working

Thanks to everybody how replyed