Need help formatting VisibleExpr for Report Designer

Hi @swartzfeger ,

The only way that I know of to accomplish conditional formatting is with overlapping controls.  Use the VisibleExpr field to make visible only the version of the control that has the desired formatting based on the criteria.

Hope this helps!

Laura

I’m trying that but also failing, lol -- this is what I have -- 3 different text boxes to each display black, blue or red:

=[InventoryItem.ItemStatus]=’AC’ AND [InventoryItem.NoteText]=0

=[InventoryItem.ItemStatus]=’AC’ AND [InventoryItem.NoteText]<>NULL

=[InventoryItem.ItemStatus]<>’AC’

It’s the first one that is causing problems… I can get the BLUE and RED to print, but the first expression is wrong.

=[InventoryItem.ItemStatus]=’AC’ AND [InventoryItem.NoteText]=0

I need to say “and inventory note is empty”, and =0 seems to make it error. Is “[InventoryItem.NoteText] Is Null” correct?

Hi @swartzfeger ,

For black the formula would be

=[InventoryItem.ItemStatus] = "AC" and [InventoryItem.Note] = null

It’s different form the SQL syntax :)

Laura

Thanks Laura, it’s appreciated. It seems to work but the BLUE expr

=[InventoryItem.ItemStatus]=’AC’ AND [InventoryItem.NoteText]<>NULL

seems to be overriding the BLACK expr

=[InventoryItem.ItemStatus]=’AC’ AND [InventoryItem.NoteText]=NULL

Maybe I need to point to something else and not .NoteText

Thanks Laura, that did the trick! I also had to change <>NULL to <>’’