Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

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

Status
Not open for further replies.

SD8146

Technical User
Jul 8, 2005
14
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.
 
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top