Convert empty string to double

adriant42 · June 7th, 2004, 03:56 PM

Hello:

Is there a way to convert an empty ("") string variable to a NULL (NOT a zero) double variable. I have tried the Val function and CDbl function. The first one gives me a 'zero' double variable. The second one gives me a run-time error.

Thank you,
Adrian T

gcianfanelli · June 8th, 2004, 03:52 AM

I think you'd need a function something like:

Code:

Public Function zerostringToNull(ByVal arg1 As String) As Variant
  Dim varOut As Variant
  varOut = Null
  If arg1 <> vbNullString Then
    varOut = arg1
  End If
  zerostringToNull = varOut
End Function

so

Code:

zerostringToNull("")

would return a Null value, but

Code:

zerostringToNull("My text")

would return a string

nano · June 8th, 2004, 04:22 AM

Thats just it, simple yet on target