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
>
Tidak ada komentar:
Posting Komentar