If a Column is blank in a Table box can I supress/hide the column within that table box?

[Anonymous]

Hello, I have a list box that has an X as a column indicators, see table below...

ID          Color          Stone     Red          White

1            Red           Ruby        x                     

2            Red           Ruby       x                

based on my selection from my list box the X indicators change from Red, white ect. Is there a way to hide a column if there not a value or if the column is blank? What I would like to see

ID         Color         Stone    Red      

1            Red          Ruby      x                    

2            Red          Ruby      x    

I have the below but it just clears the label and the column still displays. Thoughts?

=

IF([White] ='',null(),[White])

Message was edited by: John mingus

[Anonymous]

Thank you for the suggestion and the formula to hide columns. Once last question on the maxstring above. What if I want to hide a column that has blanks or null values, how would that formula look?

[jagan]

Hi,

Try like this

=Len(Trim(MaxString(White))) > 0

Regards,

Jagan.