Gary-
Set the Triple State property of the check box to Yes.
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Gary D. Schwartz
Sent: Tuesday, June 28, 2011 6:03 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Three state (Yes, No, blank) controls
Hi:
I am trying to replicate in an Access form a feature found in other
db software.
In other software, you can have a check box that has three possible
states: "Yes" or 1, "No" or 0, and blank. "Yes.shows as a check mark,
"No" shows as a blank white box, and blank shows as gray on the form.
The Access checkbox has two states: "Yes" or 1, "No" or 0.
We would like to do this to separate the "No" answers from the cases
where nothing was ever entered (blank, NULL, missing).
If I need to, I can do a combo box, but thought a check box format
would be faster and more elegant.
Any thoughts?
Thanks,
Gary
--------------------------------------------------------
Gary D. Schwartz Please reply to: gary.schwartz@pobox.com
------------------------------------
Yahoo! Groups Links
Tidak ada komentar:
Posting Komentar