<div>
I assume that the option group is bound to a field in the table that is the RecordSource for your report.<br />
<br />
If that is the case, then you should be able to use the Report detail sections Format or Print event to execute code similar to:<br />
<br />
me.label1.Visible = (me.[BoundField] = 1)<br />
me.label2.Visible = (me.[BoundField] = 2)<br />
<br />
or something along those lines. &nbsp;Try the format event first.
</div>


I assume that the option group is bound to a field in the table that is the RecordSource for your report.

If that is the case, then you should be able to use the Report detail sections Format or Print event to execute code similar to:

me.label1.Visible = (me.[BoundField] = 1)
me.label2.Visible = (me.[BoundField] = 2)

or something along those lines.  Try the format event first.

<div>
It worked very well.<br />
Thank you and have a nice day.
</div>


It worked very well.
Thank you and have a nice day.

<div>
<div class="content wysiwyg-content">
Hi guys,<br />
<br />
I have a form option group named opt_group1 including 2 check boxes named check1 and check2. <br />
On a report I have 2 labels named label1 and label2.<br />
I would like to have the label1 visible and label 2 non-visible when I check the check1, the label2 visible and label1 non-visible when I check the check2 and no label visible when no check box is checked.<br />
Can anyone please tell me how to do this?<br />
Thank you
</div>
</div>


Hi guys,

I have a form option group named opt_group1 including 2 check boxes named check1 and check2. 
On a report I have 2 labels named label1 and label2.
I would like to have the label1 visible and label 2 non-visible when I check the check1, the label2 visible and label1 non-visible when I check the check2 and no label visible when no check box is checked.
Can anyone please tell me how to do this?
Thank you

Form option group

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.