[RESOLVED] Invalid use of Null

[Kuamr]

I get the error Saying
"Invalid Use of Null"

My code for Checking Null value is

IIf(IsNull(rs!replyMessage), "", Trim(Replace(rs!replyMessage, "'", "")))

Is something wrong in the code...

Thanks

[shakti5385]

IIf(IsNull(rs!replyMessage), "", Trim(Replace(rs!replyMessage), "'", ""))

[Kuamr]

Hi Shakti,

IIf(IsNull(rs!replyMessage), "", Trim(Replace(rs!replyMessage), "'", ""))

if a remove the last bracket i.e ")" it gives a complie error saying
"argumetn not optional "

and the replace function is higlighted

[gavio]

Replace() function must be in the same format you had it in post #1:

Replace[COLOR=Red]([/COLOR][I][expression][/I], [I][find][/I], [I][replace][/I][COLOR=Red])[/COLOR]

[Kuamr]

Is this code wrong ??

IIf(IsNull(rs!replyMessage), "", Trim(Replace(rs!replyMessage, "'", "")))

Or am i missing out something...

[jcis]

IIF always Returns 2nd or 3rd parameter, depending on the condition in the first parameter, if this condition is True it returns 2nd parameter, else it returns 3rd parameter. But here you are not using the returned string, thats the error. Do something like:

Dim a As String
   a = IIf(IsNull(rs!replyMessage), "", Trim(Replace(rs!replyMessage, "'", "")))

[bushmobile]

aside from the need as assign the value as jcis pointed out - the error is because both the second and third conditions are evaluated, regardless of the first - so if rs!replyMessage is indeed Null, VB still attempts to do the replace, and you get the error.

You shouldn't use the IIf construct, it's really slow (and in this case not need), the following would suffice:

Dim a As String
 
a = Trim$(Replace(rs!replyMessage & "", "'", vbNullString))

[Kuamr]

Tried using

Dim a As String
   a = IIf(IsNull(rs!replyMessage), "", Trim(Replace(rs!replyMessage, "'", "")))

still the same error

[Kuamr]

You shouldn't use the IIf construct, it's really slow (and in this case not need), the following would suffice:

Dim a As String
 
a = Trim$(Replace(rs!replyMessage & "", "'", vbNullString))

Hi Bush,
Does this check for Null values ??

[ganeshmoorthy]

try this

IIf(IsNull(rs!replyMessage), "", Trim(Replace((rs!replyMessage & ""), "'", "")))

[bushmobile]

Hi Bush,
Does this check for Null values ??

if it's null it'll return ""

[Kuamr]

Both Methods Work!!!

Thank you Bush
Thank You Ganesh