John
Maybe it's my lousy graphics card here at work. I just tested on my other computer and it worked as it should.
Bill
--- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@...> wrote:
>
> 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