Hi all,
I think I’m screwing up my VisibleExpr -- If an InventoryID contains ‘SIM’, I want it to display a text field, but I think I messed up the syntax as I’m getting an error.
=IIf( InStr( [AMProdItem.InventoryID], 'SIM' )<0, False )
Is there a better way to define ‘contains’ in the expression?
Best answer by lauraj46
View original
+7
Hi
In your expression you are missing the False argument. I think it should be something like this:
=IIf( InStr( [AMProdItem.InventoryID], 'SIM' )<0, False, True )Hope this helps!
Laura
Hi
In your expression you are missing the False argument. I think it should be something like this:
=IIf( InStr( [AMProdItem.InventoryID], 'SIM' )<0, False, True )Hope this helps!
Laura
Sorry for the late reply Laura but your expression was perfect. I definitely need to read up on expressions so I can learn to parse these better and recognize errors more quickly!
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.