[AccessD] vbTrue vbFalse

[Charlotte Foust]

I'm convinced we're lab rats in a Microsoft testing maze and they do that
sort of thing on purpose!  😶

Charlotte Foust
(916) 206-4336

On Mon, Jun 20, 2016 at 2:41 PM, Stuart McLachlan <stuart at lexacorp.com.pg>
wrote:

> Yes, you're correct.   They've confused us by using the word TriState in
> different ways in
> differetn places :-(
>
> --
> Stuart
>
> On 20 Jun 2016 at 14:16, Gustav Brock wrote:
>
> > Hi Stuart
> >
> > I also had tristate checkboxes in mind, but I believe we have been
> > fooled - see my note to Bill.
> >
> > If the checkbox option Tristate is marked as False, it will switch
> > between True and False when clicked. However, marked as True, it will
> > switch between True and False and Undetermined where the value it
> > holds when Undetermined is Null. Also, Null is the only value that -
> > when assigned to its Value - will set the checkbox as Undetermined.
> > Any other value except 0 will set it to checked (True).
> >
> > So vbTriState (with the equivalent numeric value of -2) is not
> > intended for use with tristate checkboxes.
> >
> > /gustav
> >
> > -----Oprindelig meddelelse-----
> > Fra: AccessD [mailto:accessd-bounces at databaseadvisors.com] På vegne af
> > Stuart McLachlan Sendt: 18. juni 2016 00:32 Til: Access Developers
> > discussion and problem solving <accessd at databaseadvisors.com> Emne:
> > Re: [AccessD] vbTrue vbFalse
> >
> > They are intended for use whereever there is a tri-state possibility
> > (i.e. true/false/not stated).
> >
> > Commonly used with TriState checkboxes and various Format functions.
> >
> >
> > And they are not new - they're described in the Getz/Gilbert VBA
> > Handbook (circa 2000)
> >
> >
> > On 17 Jun 2016 at 18:52, Gustav Brock wrote:
> >
> > > Hi all
> > >
> > > I discovered these new constants:
> > >
> > > https://msdn.microsoft.com/en-us/library/office/gg278431(v=office.15
> > > ). aspx
> > >
> > > There is also a vbUseDefault.
> > >
> > > Where/how would you use those?
> > >
> > > /gustav
> >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
>
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>