iserror and better

[oaishm]

I have this statement

iif(iserror(left(long_text,instr(long_text,"/")),long_text,left(long_text,instr(long_text,"/")))

so if long_text is asdfsf/sdfs
it will return asdfsf

and if its
asdfsf
it will return asdfsf

But alas... When there's no "/" in the long_text, instr evaluates to 0 and left throws an error and iserror is only good for numeric items. Is there something better than iserror, or do I have to do something like instr()>0.

 

[xenou]

Yes, should work with Instr()
=IIF(Instr(1,long_text,"/")>0,Left(long_text,Instr(1,long_text,"/")-1),long_text)

 

[oaishm]

There's no catchall iserror function? I've got to test every input of a string of functions and not just let the error trickle down until the iserror catches it at the end of the function?

 

[xenou]

I don't think there is a catchall iserror function but I could be wrong. You probably could create such a function with VBA. But I'm not sure what you mean by a string of functions or why an error would be caught at the "end of the function". The example we looked at above seems straightforward and effective to me.

ξ

 

[oaishm]

I didn't want to have to debug functions or catch type mismatches etc. I just wanted to know if there was some error, and if there was to echo out something like 0.

 

[xenou]

I'm afraid I need a practical example. I rarely encounter errors in Access due to the stricter data typing (i.e., as compared to Excel).

ξ