PDA

View Full Version : Object required error



Asterix
01-25-2008, 12:56 PM
If Not lowest_score.Comment.Text Is Nothing Then

If lowest_score.Comment.Text evaluates to "1.13" in the watch window, then why do I get an "Object required" error when I run the line above?

akn112
01-25-2008, 01:25 PM
i believe "is nothing" is associated with an object, but your .text is just a string. it would be better to use isnull()

Bob Phillips
01-25-2008, 02:57 PM
Dim cmtValue As String
On Error Resume Next
cmtValue = lowest_score.Comment.Text
On Error GoTo 0
If cmtValue <> "" Then

'...
End If

Aussiebear
01-25-2008, 09:30 PM
[cba]

Dim cmtValue As String
On Error Resume Next
cmtValue = lowest_score.Comment.Text
On Error GoTo 0
If cmtValue <> "" Then

'...
End If
[/vba]

[cba] ....must be a British thing...

Carl A
01-25-2008, 09:58 PM
[cba] ....must be a British thing...
ROFL:rofl: