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

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.

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

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"forest8" wrote in message
...
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.

--
Build a little, test a little.


"forest8" wrote:

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.

Hi

Thanks. I fixed the property and now it works.



"forest8" wrote:

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.