Page 1 of 1

Turning TextBox on/off given null data

Posted: Thu Sep 03, 2015 11:06 pm
by jrSD
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.

Re: Turning TextBox on/off given null data

Posted: Fri Sep 04, 2015 6:36 am
by Alex K.
Hello,

Please send us your report template for analysis.

Thank you.

Re: Turning TextBox on/off given null data

Posted: Fri Sep 04, 2015 3:46 pm
by jrSD
I actually achieved what I needed by turning the text / textbox white given the null...Thank you.

Re: Turning TextBox on/off given null data

Posted: Mon Sep 07, 2015 6:13 am
by HighAley
Hello.

Good. Let us know if you need any additional help.

Thank you.