yes/no report help

[nirie1]

I have created a database that has a yes/no checkbox. I want the
checkbox to only show in the report when there is a yes value. I need
the checkbox for the form so I dont want to get rid of it.

If for some reason I have to change the checkbox to a text box will the
data be deleted?

I am not really good at access. I am self taught. I can do stuff when
told how to. I have no vba exeperince.

 

[Damon Heron]

in the detail section properties of the report, select format, and paste
this code, substituting your names

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Me.Checkbox1.Visible = (Me.Checkbox1 = True)
End Sub

HTH
Damon

 

[Marshall Barton]

I have created a database that has a yes/no checkbox. I want the
checkbox to only show in the report when there is a yes value. I need
the checkbox for the form so I dont want to get rid of it.

If for some reason I have to change the checkbox to a text box will the
data be deleted?

I am not really good at access. I am self taught. I can do stuff when
told how to. I have no vba exeperince.

Please don't post the same querstion multiple times. I
tried to answer this in another thread.