Bill-
I just tried it in Northwind 2007 by adding an Integer "Inactive" field to
Customers. When I use a Triple-State checkbox, it appears partly colored in
when Null, blank when 0, and checked when -1.
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 Bill Mosca
Sent: Tuesday, June 28, 2011 6:51 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Three state (Yes, No, blank) controls
John
YOu have to use an integer for a triple state check box, right?
I've never got that to work for me. Using the themed controls in 2003, the null
state looks just like the unchecked state. Am I doing something wrong?
Bill
--- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@...> wrote:
>
> 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@...
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
------------------------------------
Yahoo! Groups Links
Tidak ada komentar:
Posting Komentar