IsNull and <>""

[mattalexx]

Is there a shorter expression that brings the same result as "IsNull(ctrl.Value) Or Len(Trim(ctrl.Value)) = 0"?

For example:

    If IsNull(ctrl.Value) Or Len(Trim(ctrl.Value)) = 0 Then
        str = "nuthin here"
    End If

    ' equals

    If ???? Then
        str = "nuthin here"
    End If

Matt(+)

[Lord_Rat]

What about just
If Len(Trim(ctrl.value))<1 then
'nothing here
End if

[peet]

don't think Trim on Null vlues will work Lord_Rat

[mattalexx]

That doesn't work for null values

Len(Trim(Null)) = Null
Null < 1 = Null '<--type mismatch

[Lord_Rat]

Admittedly, I didn't try it this time.

Let me give it a whirl.

[peet]

mattalexx, I think the way u do it is it...

[Lord_Rat]

What kind of control?

Using a text box, Trim works fine, as in the attached.

[mattalexx]

I'm running this function for fields in a DAO recordset.

[DDfunbags]

what about

If (IsNull(ctrl.Value)) Or (ctrl.Value) = "") Then
'Nothing is there
End If


That'll work if the data is going to be a text or a number

[mattalexx]

That's essentially the same as what I proposed in the beginning, isn't it?

Matt(+)

[WALDO]

If Len(Value & "") = 0 Then
    'Nuthin there
End If

The definition for Null as it applies to VB is not the same definition for null as it applies to a recordset. IsNull() isn't 100% effective in this case, but the preceeding code hasn't failed me yet.

[Alain]

Waldo: Just for fun, how many times have you answered this one in the furums yet?

[WALDO]

Ummm, how many posts do I have?

[mattalexx]

I'm sorry, but sometimes the simplest problems are the hardest to find answers to.

Thank you very much for your help, Waldo, it is much appreciated.

Matt(+)

[WALDO]

I'm just glad I could help.