If using checkbox, how to show checkbox and value

Hi there

In my database, there are instances of checkbox usage.  Is it possible to
have the checkbox and a "Yes/No" adjacent to the box?

That is, if the response is yes, I want to see a checkbox and Yes or if the
response is no, I want to see a blank box and No.

Thank you in advance.

Hi,You could put an unbound textbox on the form in the appropriate place

Hi,

You could put an unbound textbox on the form in the appropriate place and
set its controlsource to:
=IIf(chkCheckbox = -1,"YES","NO")

Hope this helps,
Alex.

Forest8,In an unbound text box place...

Forest8,

In an unbound text box place...

=IIf([YourCheckboxName] = True, "Yes","")

--
Gina Whipp
2010 Microsoft MVP (Access)

II

http://www.regina-whipp.com/index_files/TipList.htm

Hi there

In my database, there are instances of checkbox usage.  Is it possible to
have the checkbox and a "Yes/No" adjacent to the box?

That is, if the response is yes, I want to see a checkbox and Yes or if the
response is no, I want to see a blank box and No.

Thank you in advance.

forest,You wrote...That's a bit confusing.

forest,
You wrote...
That's a bit confusing.  Sounds like you want to respond somewhere
else on the form, and then have the checkbox checked/unchecked, and also
Yes/No accordingly.
With a checkbox, checking/unchecking the box itself should be the only
response needed.

I think you mean...
it.   And, when I uncheck the box, I want to see "No" right beside it."

Place an unbound text control next to your checkbox.
Give it a Control Source of...
= IIf([chkYourName] = True, "Yes", "No")
As chkYourName is checked/unchecked, "Yes" and "No" will dsiplay
accordingly.
--
hth
Al Campagna
Microsoft Access MVP 2007-2009
http://home.comcast.net/~cccsolutions/index.html

You can just add a text box bound to the yes/no field and set the

You can just add a text box bound to the yes/no field and set the format
property to display yes/no. There is no need for IIf() expressions.  If you
want the text box to be read-only, set its Locked property to Yes and
Enabled to No.


--
Duane Hookom
MS Access MVP

Thanks to everyone who responded to my query."Al Campagna" wrote:

Thanks to everyone who responded to my query.