hide or unhide report column from checkbox (1 Viewer)

mo7kenawy

New member
Local time
Today, 15:00
Joined
Aug 27, 2020
Messages
12
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
 

Attachments

  • ex.accdb
    440 KB · Views: 139
Last edited:

theDBguy

I’m here to help
Staff member
Local time
Today, 06:00
Joined
Oct 29, 2018
Messages
21,357
Hi. Welcome to AWF!

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

mo7kenawy

New member
Local time
Today, 15:00
Joined
Aug 27, 2020
Messages
12
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
 

Attachments

  • ex.accdb
    444 KB · Views: 131

theDBguy

I’m here to help
Staff member
Local time
Today, 06:00
Joined
Oct 29, 2018
Messages
21,357
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.
 

Attachments

  • ex.zip
    31.9 KB · Views: 145

mo7kenawy

New member
Local time
Today, 15:00
Joined
Aug 27, 2020
Messages
12
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

I’m here to help
Staff member
Local time
Today, 06:00
Joined
Oct 29, 2018
Messages
21,357
thank you bro please help me to make label width = 0 if checkbox false
Maybe try something like:
Code:
If Nz(Forms!Form1.CheckboxNumber,False) = False Then
    Me.ControlName.Width=0
End If
 

Users who are viewing this thread

Top Bottom