jprochelle
Technical User
I have a report with a yes/no field. In report form, it looks fine. But when I export to work the checkbox disappears and you can't view the data. How can I get the report to print "Yes" if the checkbox is not null?
Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If (me.yourCheckbox.value=-1 Then ' -1 = checked
me.yesTextBox.value="Yes"
Else ' 0 = not checked
me.yesTextBox.value="No"
End If
End Sub