Re: How can I toggle a Yes/No check box and display value in adjoining field ?
- From: "Wolfgang Kais" <w.kais@xxxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 25 Oct 2007 09:51:05 +0200
Hello.
Mark wrote:
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")
--
Regards,
Wolfgang
.
- Follow-Ups:
- References:
- Prev by Date: How can I toggle a Yes/No check box and display value in adjoining field ?
- Next by Date: Re: Testing for existance of a record
- Previous by thread: How can I toggle a Yes/No check box and display value in adjoining field ?
- Next by thread: Re: How can I toggle a Yes/No check box and display value in adjoining field ?
- Index(es):
Relevant Pages
|