IF statement in report

[matey56]

Hi all,


I have a form with several fields that have numbers for the data (1, 2, 3, etc.) In my report I'd like those fields where there's data to show as checkmarks or X's. If the field is blank, no check of course. How can I write a statement in my report to do that?

[CJ_London]

Use a checkbox with your number field as its control source.

Wih an access Boolean ((which a checkbox represents) 0 is false and any other value is true

[matey56]

Use a checkbox with your number field as its control source.

Wih an access Boolean ((which a checkbox represents) 0 is false and any other value is true

I forgot to mention some of the fields have text and some have digits. I created the checkboxes and used the aforementioned fields as controls. If the field contains any text=check and if it's blank=no check. How do I write that statement and where does it go?

[CJ_London]

For text use something like
=len(fieldname)

[matey56]

For text use something like
=len(fieldname)

Where does that statement go?

[CJ_London]

in the controlsource of the checkbox control

[matey56]

in the controlsource of the checkbox control

That worked perfectly, thank you!