code for yes/no checkboxes

[pazgb]

I need to check yes/no checkbox fields to see if it is checked in table per record. Then, if the checkbox is checked, I need to display the field name(s) on the report.

Anyone have any ideas?

Michael

 

[BillPower]

Hi pazgb,

You could try something like this in your Report's controls:

If Me!MyCheckBoxName = True then
Me!MyReportControl1 = Me!WhatEverOtherControl1
Me!MyReportControl2 = Me!WhatEverOtherControl2
Me!MyReportControl3 = Me!WhatEverOtherControl3
End if

Bill

 

[pazgb]

It won't let me set the text property in the report. I can check to see if it is true but i can't set the value to the text property in the report.

 

[SeeThru]

You can set the visible property in the ONformat in the report...

OnFormat

If forms!myform!mycheckbox = true then
me!mylabel1.visible=true
me!mylabel2.visible=false
else
me!mylabel1.visible=false
me!mylabel2.visible=true
end if

End sub



Even simpler, if you are just setting one..

Onformat

me!mylabel.visible-forms!myform!mycheckbox

End sub


HTH

 

[pazgb]

That will probably work, but I dont have alot of space on the report, I would have about 60 different labels. Is there a way to concantante a variable so it can all be combined into one label?

Like if checkbox1=true then
concantantedVar = concantantedVar + checkbox1Var
end if
if checkbox2=true then
concantantantedVar = concantantedVar + checkbox2Var
end if

something like that. would that work?