Changing a Number to Text in a Report

[Garridon]

I have a report which tracks whether someone has turned in a form to us.&nbsp;&nbsp;For the data entry, it's a checkbox, and the information is stored as a 1 (Yes) and a 2 (No).&nbsp;&nbsp;The field in the table is a text field.<br><br>When I put the fields on a report, they come out as 1 and 2, and I want to change them to Yes and No.&nbsp;&nbsp;How do I do that?&nbsp;&nbsp;Any help would be greatly appreciated.<br><br><br> <p>Linda Adams<br><a href=mailto:Garridon@aol.com>Garridon@aol.com</a><br><a href=

http://www.geocities.com/hallona_2000>Linda

Adams Online</a><br>I'm a professional writer, published internationally.

 

[kathryn]

Is it too late the change the design of the table to make the field a Yes/No field?&nbsp;&nbsp;If not, I would probably do that.<br><br>If it is too late, then create a query and change the 1 and 2 to a Yes and No in the query.&nbsp;&nbsp;Create a new field in your query by entering the following in one of the columns:<br><br>Form Returned:Iif([YourTableName]![YourFieldName]=&quot;1&quot;,&quot;Yes&quot;,&quot;No&quot<br><br>Hope that helps. <p>Kathryn<br><a href=mailto: > </a><br><a href= > </a><br>

 

[Umbane]

Create an unbound textbox in the detail section of the report, call it say &quot;answer&quot; then you could write some code in the on format procedure of the report;

If txtanswer = 1 then
Me!answer = &quot;Yes&quot;
elseif txtanswer = 2 then
Me!answer = &quot;No&quot;
End If

Umbane