convert a zero length string

[seeker4]

I am trying to convert a zero length string to an
integer. When I use cint(string) I receive a type
mismatch error. How can this be done? I am needing to
sum values in text boxes and some of them have no value.
I have tried textbox.text but then an error is given that
I cannot use a method unless the control has focus. Any
suggestions?

seeker4

 

[Douglas J. Steele]

A zero-length string is "", so you can't convert it to an integer. Are you
sure it's a ZLS, and not Null? Converting Null is easy: use the Nz function.

 

[Joe Fallon]

iif(myfield="",0,"")
--
Joe Fallon

A zero-length string is "", so you can't convert it to an integer. Are you
sure it's a ZLS, and not Null? Converting Null is easy: use the Nz function.

 

[Douglas J. Steele]

I think you meant iif(myfield="",0,myfield)

And AFAIK iif(Len(myfield)=0,0,myfield) is actually more efficient.

 

[Joe Fallon]

You get the idea. <g>
--
Joe Fallon

I think you meant iif(myfield="",0,myfield)

And AFAIK iif(Len(myfield)=0,0,myfield) is actually more efficient.