ACCESS FEED: RE: [MS_AccessPros] Re: Three state (Yes, No, blank) controls

Selasa, 28 Juni 2011

RE: [MS_AccessPros] Re: Three state (Yes, No, blank) controls

Bill-

Ah, right. Triple State won't work for a Yes/No field, but it will work if the
underlying field is Integer.

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:30 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: Three state (Yes, No, blank) controls

Gary

Since Access does not support null bit (Yes/No) fields, use an integer or byte
field instead. You can then use a combo box with a value list of:
Null;'Unknown';0;'No';1;'Yes'

Set the number of columns to 2.
Set the column widths to 0;1
Make sure the bound column is set to 1

Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
https://mvp.support.microsoft.com/profile/Bill.Mosca

--- In MS_Access_Professionals@yahoogroups.com, "Gary D. Schwartz"
<gary.schwartz@...> wrote:
>
> 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