DataBase - If using checkbox, how to show checkbox and value

Asked By forest8

14-Mar-10 10:58 PM

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.

14-Mar-10 11:25 PM

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.

14-Mar-10 11:30 PM

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.

14-Mar-10 11:49 PM

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

15-Mar-10 12:03 AM

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

15-Mar-10 01:03 AM

Thanks to everyone who responded to my query.