Crystal meant a bit, not a byte.
Bill
--- In MS_Access_Professionals@yahoogroups.com, Crystal <strive4peace2008@...> wrote:
>
> Hi Gary,
>
> the Yes/No data type is a byte, it only supports 2 values. You can make your field an Integer and change the DisplayControl to a checkbox using this code:
>
> CurrentDb.TableDefs("Table1").Fields("Field1").Properties("DisplayControl") = CInt(acCheckBox)
>
> Allen Browne has an excellent article on this:
>
> Why I stopped using Yes/No fields
> http://allenbrowne.com/noyesno.html
>
>
> Warm Regards,
> Crystal
>
> www.AccessMVP.com/strive4peace
>
> *
> (: have an awesome day :)
> *
>
>
> --- On Tue, 6/28/11, Gary D. 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
>
Tidak ada komentar:
Posting Komentar