*pic* Conditional Formatting to change Other Field Bold

[KrenzyRyan]

Here is what I have:



RightPart: IIf(IsNull([wc]),Null,[WC] & "-") & [WC] & "-" & IIf([endstring]<>Len([remainingoperations]),Right([remainingoperations],Len([remainingoperations])-[endstring]),Null)

[rpeare]

I don't have a copy of the database I did testing with anymore so if you want to post a copy of what you're working with I can take a look, just redact any privacy information and zip up a copy of your database and post it on this forum.

[KrenzyRyan]

Thank you sir, please see attached

[rpeare]

Your #Error is appearing on lines where the remainingoperations line is null so you'd need this formula:

RightPart: iif(isnull(remainingoperations), null,([WC] & "-" & IIf([endstring <>Len([remainingoperations]),Right([remainingoperations],Len([remainingoperations])-[endstring]),Null)))

And you would similarly need to account for the null value of remaining operations in any of the segments where on which you're using left/right/mid string functions.