Converting a field from Yes/No to Text Box not changing in a form

[forest8]

Hi

I am in the process of creating a form in which I realized that I had set up
a field in a table to be Yes/No (1 or 0). I realized that I actually need it
to read "Yes" or "No" just I converted it to a text field.

But when I check my form, it doesn't reflect my change. In other words, the
fields are blank whereas I wanted to see either a "Yes" or a "No".

How do I fix this problem without recreating the form?

Thanks in advance.

 

[Douglas J. Steele]

Are you certain that the text box is bound to the field in the table?

 

[KARL DEWEY]

If you use a calculated field ( IIF([Field] = -1, "Yes", "No") ) but you
will need to edit the form to use the alias.
Easiest way is to open form in design view, click on the box, double click,
scroll to bottom and select Properties. Set Format to Yes/No.

 

[forest8]

Hi

Thanks. I fixed the property and now it works.