Turning TextBox on/off given null data
Posted: Thu Sep 03, 2015 11:06 pm
I have two columns in my db that i am having trouble with (report wise). One column displays text in every cell / record (Parts.Face6Filename). The cell (Parts.Face6Barcode) has only limited data, wherein most of the time the cell displays null. In my report, I would like to show (Parts.Face6Filename) only when (Parts.Face6Barcode) in NOT null. I have tried to do this with conditions to no avail, and I am uncertain how to write and where to include an IIF statement for this. Any help would be greatly appreciated.