List box Column has a value?????

[Sadukar]

Hi all

How can I check if a listbox column has a value.

For Example
If Me.lstROWS__lstROWS.Column(0, 0) = (has a value) Then
MsgBox "ok"
Else
End If

any suggestions?

Thanks
s.

 

[fneily]

You can test the "listcount" property.
If Forms![FormName]![ListboxName].listcount > 0 etc.

Neil

 

[Sadukar]

thanks
s.

 

[Poteen]

Dangerous,
Column 2 may contain some NULLS..... do you see where I'm going. You're probably safer if you explicitly examine the 'cells' you're interested in eg a For Each loop with a xx<>NULL or Not(Isnull(xx))test.
regards,
John