Label format based on checkbox value (Access 2013)
A table has a Yes/No field to denote whether an item (a record) is "Fragile." On the report based on the table, the checkbox (cbxFragile) Visible property is "No." I've placed a label, "lblFragile," that reads "Fragile!" over top of the checkbox; the label also is normally not visible.
My intent is that on the report, a record will display Fragile! when "Fragile?" says Yes. I've formatted the Detail section with the following code:
Private Sub Detail_Format (Cancel As Integer, FormatCount As Integer)
If IsNull(cbxFragile) Then
lblFragile.Visible = False
lblFragile.Visible = True
What happens: On the report, nothing appears in the "Fragile" column for any record, even when there's a checkmark in the Fragile field. I know I've overlooked some small detail, probably in the code. Can someone help me see the error. Thanks!