Where to insert the "iif"

[barbados2010]

One of my reports has a record source which gets data from a checkbox that was checked on a form. There is 2 check boxes and either one is checked to indicate the desired info. Since access only allows a number of 1 or 2 I want to use iif(optionvalue=1,"F","N") to show an "F" on the report instead of displaying the 1.

Can this be done in report properties or does it have to be done in VBA?

 

[rodmc]

Yes, you can use IIF in a report.
However, Access does not just rely on the integers 1 or 2 when returning a value, you can set that yourself in the IIF statement, for example:

iif ([Qty] > 10, "large", "small")

If you are referring to the values of the check box, then its 0 and -1 or True/False