[AccessD] vbTrue vbFalse

Stuart McLachlan stuart at lexacorp.com.pg
Mon Jun 20 16:41:52 CDT 2016


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
> 





More information about the AccessD mailing list