Why does this code produce error when Field length is 0

• awheeler_01

  SSC Journeyman

  Points: 86

  More actions

  October 7, 2010 at 12:33 pm

  #100742

  The code is:

  =IIF(Len(Fields!Academic.Value)> 0, Left(Fields!Academic.Value,InStr(Fields!Academic.Value, "(") - 1), "")

  which produces and error.

  If I change the code to

  =IIF(Len(Fields!Academic.Value)> 0, Fields!Academic.Value, "") there is no error. I want to display only the characters before ")" character if the field has a value otherwise nothing. Seems simple enough but ...

  any ideas.