How can I toggle a Yes/No check box and display value in adjoining field ?

[mthornblad]

Hi

I have a test form with two fields. The first field is a Yes/No
checkbox. The second field is a text box that I want to display
"checked" if the checkbox is checked and "unchecked" if the checkbox
is not checked.

Now, if I check the checkbox the text box displays "checked".
However, if I uncheck the checkbox, "checked" remains in the text box.

I want to the text box to toggle between "checked" and "unchecked"
when I check and uncheck the checkbox.

Please let me know how I can accomplish this and thanks in advance for
your help.

Mark

 

[Wolfgang Kais]

Hello.

I have a test form with two fields. The first field is a Yes/No
checkbox. The second field is a text box that I want to display
"checked" if the checkbox is checked and "unchecked" if the
checkbox is not checked.

Now, if I check the checkbox the text box displays "checked".
However, if I uncheck the checkbox, "checked" remains in the
text box.

What have you done to make th word "checked" appear?

I want to the text box to toggle between "checked" and "unchecked"
when I check and uncheck the checkbox.

Let's assume that the checkbos is named chkMyCheckBox, then the
control source for the textbox should look like this:
=Iif([chkMyCheckBox],"checked","unchecked")

 

[mthornblad]

Hello.

I have a test form with two fields. The first field is a Yes/No
checkbox. The second field is a text box that I want to display
"checked" if the checkbox is checked and "unchecked" if the
checkbox is not checked.

Now, if I check the checkbox the text box displays "checked".
However, if I uncheck the checkbox, "checked" remains in the
text box.

What have you done to make th word "checked" appear?

I want to the text box to toggle between "checked" and "unchecked"
when I check and uncheck the checkbox.

Let's assume that the checkbos is named chkMyCheckBox, then the
control source for the textbox should look like this:
=Iif([chkMyCheckBox],"checked","unchecked")

Wolfgang

You da man !!!

Thanks for your help. That's exactly what I wanted to know. Maybe I
didn't ask the question correctly
but you were able to hit the nail on the head. You don't know how
happy I am. I was banging my head
on the wall trying to figure it out. Maybe I'm not the brightest bulb
on the tree but thanks to you I am
able to forge ahead.

Thanks

Mark

 

[Guest]

I am Celine

Hello.

I have a test form with two fields. The first field is a Yes/No
checkbox. The second field is a text box that I want to display
"checked" if the checkbox is checked and "unchecked" if the
checkbox is not checked.

Now, if I check the checkbox the text box displays "checked".
However, if I uncheck the checkbox, "checked" remains in the
text box.

What have you done to make th word "checked" appear?

I want to the text box to toggle between "checked" and "unchecked"
when I check and uncheck the checkbox.

Let's assume that the checkbos is named chkMyCheckBox, then the
control source for the textbox should look like this:
=Iif([chkMyCheckBox],"checked","unchecked")

Wolfgang

You da man !!!

Thanks for your help. That's exactly what I wanted to know. Maybe I
didn't ask the question correctly
but you were able to hit the nail on the head. You don't know how
happy I am. I was banging my head
on the wall trying to figure it out. Maybe I'm not the brightest bulb
on the tree but thanks to you I am
able to forge ahead.

Thanks

Mark