Display checkmark based on condition?

[JroTek]

I am trying to display a check mark on a report. I want the check mark to display if a field called "status" has any value. If it has no value, I do not want a check the check mark to display. The field called "status" is not a yes/no field.

Thank you,
Jonathan

 

[formerTexan]

Hello Jonathan,

Add this function to the report's code module

Private Function fConvert(var As Variant) As Boolean
    If Not IsNull(var) Then
        fConvert = True
    End If
End Function

Then call the function from the checkbox by adding the following for the checkbox's controlsource

=fConvert([Status])

Cheers,
formertexan

 

[dhookom]

You shouldn't need any code. Use a text box:
Control Source: =IIf(IsNull([Status]),Null,"ü")
Font Name: Wingdings



Duane
Hook'D on Access
MS Access MVP