Convert List box to text box in a report

[Deb]

In my forms, I have a list box that contains the choices,
yes, no and sometimes. However, in my report, I want the
response to just be a text box containing the answer.
Right now when I convert it to a text box, it just puts a
0 or -1 on the report. How do I change the 0 and
negative to say yes or no on the report?

--Deb

 

[Jeff Boyce]

Deb

Listbox and text are types of controls. What's the underlying data field
type?

Also, if you put an unbound textbox on your report, you can set it's
ControlSource property to something like (actual syntax may vary):

=IIF([YourFieldName]=0,"No","Yes")