[AccessD] vbTrue vbFalse

[Gustav Brock]

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