How can I display "1" as "Yes2 and "2" as "no&quot 1

[SD8146]

I have a Microsoft Access Report that displays 1's and 2's where "1" = "yes, and "2" = "No". I would like to make the report more explicit and show "Yes" and "No" rather than "1" and "2" - what code would I use to do this please.

 

[lupins46]

set the controlsource to:

=iif(myfieldname=1,"Yes","No")

 

[SD8146]

Fantastic!! Had a few problems with errors but when I realised that I needed to change the textbox 'Name' to something other than "myfieldname" it worked a treat. Thank you.