Looks like Crystal's suggestion and the Alan Browne article she
linked, is going to do the trick.
It would have been nicer to know they wanted this at the beginning,
instead of needing to convert several dozen fields from Yes/No to this.
Thanks all,
Gary
At 12:25 PM 6/28/2011, you 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,
--------------------------------------------------------
Gary D. Schwartz Please reply to: gary.schwartz@pobox.com
Tidak ada komentar:
Posting Komentar