hide or unhide report column from checkbox (1 Viewer)

[mo7kenawy]

Hello all,

please I need help

I have a table with 5 columns "FName, LName, Age, Salary, Date"
and I have form with 5 checkboxes "FName, LName, Age, Salary, Date"
and 1 button for open report for all values in this table

I need if I checked EX. "FName, Age"

the report shows only "FName, Age"

i attached ths expamle

sorry my English not good

 

[theDBguy]

Hi. Welcome to AWF!

That might require the use of some code. Not sure if it can be done without using some code.

 

[mo7kenawy]

Hi. Welcome to AWF!

That might require the use of some code. Not sure if it can be done without using some code.

if you can help me please give me a code i attached a example

 

[theDBguy]

if you can help me please give me a code i attached a example

Hi. Just as an example, I only did FName and LName and did not touch the header labels. You should be able to do the rest, if you decide to use this approach.

 

[mo7kenawy]

Hi. Just as an example, I only did FName and LName and did not touch the header labels. You should be able to do the rest, if you decide to use this approach.

thank you bro please help me to make label width = 0 if checkbox false

 

[theDBguy]

thank you bro please help me to make label width = 0 if checkbox false

Maybe try something like:

If Nz(Forms!Form1.CheckboxNumber,False) = False Then
    Me.ControlName.Width=0
End If

 

[mo7kenawy]

Maybe try something like:

If Nz(Forms!Form1.CheckboxNumber,False) = False Then
    Me.ControlName.Width=0
End If

Thank U bro

 

[theDBguy]

Thank U bro

You're welcome. Good luck with your project.