Report Checkboxes for Memo and Numeric Fields

[mstery]

I can't figure out how to do this. I want to use 2 checkboxes on a
report to display as checked or unchecked, depending on the values of a
Memo field and a Numeric field. If the memo field is not null, I want
the box to be checked, but if it's null, I want it unchecked. If the
Numeric field value is 1, the box should be checked, but if it's 2, I
want it unchecked. There is a reason I can't make the Numeric field in
the underlying table a Yes/No field. Is this possible? Thanks for any
help.

 

[Marshall Barton]

I can't figure out how to do this. I want to use 2 checkboxes on a
report to display as checked or unchecked, depending on the values of a
Memo field and a Numeric field. If the memo field is not null, I want
the box to be checked, but if it's null, I want it unchecked. If the
Numeric field value is 1, the box should be checked, but if it's 2, I
want it unchecked. There is a reason I can't make the Numeric field in
the underlying table a Yes/No field. Is this possible?

You do not want a field in your table for this. It's easu
enough to calculate the check boxes whenever you want.

Either in the report's record source query or in the check
box's control source expression:
=[memo field] Is Not Null
and
=[numeric field] = 1

If you do this in the record source query, don't include
the = sign.