Convert List box to text box in a report

  • Thread starter Thread starter Deb
  • Start date Start date
D

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
 
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")
 
Back
Top