Expression If statement inside a report

[JoeJr]

hey everyone,

I am working on a report that has a checkbox that is being pulled from a table. What I am looking to do is replace that checkbox on the report with a textbox. I want it to populate an X if the checkbox is checked with a checkmark "True" in the table. The Report source is the table but on the txt box I cant figure out how to write the expression that represents what I am trying to do. the table field name is "CORRECTEDENTRY" and the txt box on the form is "txtCE"

Thank you

[pbaldy]

What if it's false? Generally:

=IIf(FieldName = True, "X", "")

[JoeJr]

What if it's false? Generally:

=IIf(FieldName = True, "X", "")

Thank you for the response. Yes if the field is not checked "False" I dont want it to do anything "input data" into that field.

[pbaldy]

Did you try the suggestion?

[JoeJr]

Did you try the suggestion?

It worked!!

Thank you

[pbaldy]

Happy to help!