[AccessD] vbTrue vbFalse

[Gustav Brock]

Hi Bill

Yes, I can see them being used for the three possible options for the parameter in FormatNumber.

And I misread the explanation at the link. "Optional. Tristate constant ... " doesn't mean an optional tristate constant but: "(one of) _the_ vbTriState constants as vbTriState is an enumeration holding the three constants:

    vbFalse
    vbTrue
    vbUseDefault

so they are intended for use where you have parameters declared as vbTriState.

Now it makes sense to me. Thanks!

/gustav

-----Oprindelig meddelelse-----
Fra: AccessD [mailto:accessd-bounces at databaseadvisors.com] På vegne af Bill Benson
Sendt: 17. juni 2016 23:20
Til: Access Developers discussion and problem solving <accessd at databaseadvisors.com>
Emne: Re: [AccessD] vbTrue vbFalse

Looks applicable to the FormatNumber function in Access VBA?

https://support.office.com/en-us/article/FormatNumber-Function-91030eab-2887-43d4-9c17-311ab6ebf43b?ui=en-US&rs=en-US&ad=US&fromAR=1


On Fri, Jun 17, 2016 at 2:52 PM, Gustav Brock <gustav at cactus.dk> 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