HI,

I have created an if statement to get rid of any label where the corresponding field is empty or null, its no performaing as it should.

Can anyone see anything wrong?

thanks david

Private Sub Check_Controls()

If [Sku] Is Null Or [Sku] = "" Then Label15.Visible = False

Else

Label15.Visible = True

End If

End Sub

Try:
If Len([Sku] & "") = 0 Then
Label15.Visible = False
Else
Label15.Visible = True
End If...and please delete your duplicate thread. Edit the 1st post in the other thread and delete the entire thread.