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