hide or unhide report column from checkbox

mo7kenawy

New member
Local time
Today, 11:56
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

Last edited:
Hi. Welcome to AWF!

That might require the use of some code. Not sure if it can be done without using some code.
 
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

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

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
 
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

Back
Top Bottom