[AccessD] vbTrue vbFalse
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 :-(
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.
> -----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
> Website: http://www.databaseadvisors.com
More information about the AccessD