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

  • Thread starter Thread starter forest8
  • Start date Start date
F

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.
 
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.
 
Back
Top