Add or Remove column from same report by selecting checkbox

[Ashisht76]

Hi Everyone,

I have been searching for code that can add or remove column from same report based on check box is selected or not. Is it really possible or its not practical. Does .visible property works here and if so how, I will he very thankful if i get some hint or code example of the same.

I am highly obliged in advance for reading / responding on my post.

 

[CJ_London]

you can set visibility in the report section onformat event.

 

[Ranman256]

the chkbox event would show or hide the field

sub chkBox1_Afterupdate()
   txtBox1.visible - chkBox1.value
end sub