I am curious how Msgbox combines multiple arguments into 1 for
vbMsgBoxStyle(e.g. vbInformation + vbYesNo), as I would like to implement
something like this in one of my own procedures.

Another question I am curious about is how to display argument options when
writing a procedure call. Again, similar to Msgbox, when building the
procedure call, the code window displays a list of options for each argument.

Any help is appreciated.

Devlin

Re your first question, use powers of 2 for each element, and then parse
them with a binary AND operation.

There's an example in this Database Issue Checker Utility:
http://allenbrowne.com/Ap****ueChecker.html
You check the box for each issue you wish to check.
The form treats each as a power of 2, sums the values, and passes the result
to the function. The function then ANDs with 1, 2, 4, 8, etc, to determine
which bits are turned on.

Re your second question, use an Enum or custom Type. Then declare your
argument as this type, and the options are available.

You can even use the built-in types. For example, if your code has to accept
some type of Access object (form, report whatever), you could declare it
like this:
Public Function MyFunc(WotObject As acObjectType)

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.


"DevlinM" <(E-Mail Removed)> wrote in message
newsB004C5C-9125-4F01-B138-(E-Mail Removed)...
> I am curious how Msgbox combines multiple arguments into 1 for
> vbMsgBoxStyle(e.g. vbInformation + vbYesNo), as I would like to implement
> something like this in one of my own procedures.
>
> Another question I am curious about is how to display argument options
> when
> writing a procedure call. Again, similar to Msgbox, when building the
> procedure call, the code window displays a list of options for each
> argument.
>
> Any help is appreciated.
>
> Devlin
>

You have to be careful, if you use + instead of AND:


MsgBox "Hello", vbOKCancel + vbOKCancel

as example, does not produce an OK - Cancel, while


MsgBox "Hello",vbOKCancel AND vbOKCancel


does.


Vanderghast, Access MVP


"DevlinM" <(E-Mail Removed)> wrote in message
newsB004C5C-9125-4F01-B138-(E-Mail Removed)...
>I am curious how Msgbox combines multiple arguments into 1 for
> vbMsgBoxStyle(e.g. vbInformation + vbYesNo), as I would like to implement
> something like this in one of my own procedures.
>
> Another question I am curious about is how to display argument options
> when
> writing a procedure call. Again, similar to Msgbox, when building the
> procedure call, the code window displays a list of options for each
> argument.
>
> Any help is appreciated.
>
> Devlin
>

"vanderghast" <vanderghast@com> wrote in message
news:F85B0A5E-0451-454E-8F74-(E-Mail Removed)...
> You have to be careful, if you use + instead of AND:
>
>
> MsgBox "Hello", vbOKCancel + vbOKCancel
>
> as example, does not produce an OK - Cancel, while
>
>
> MsgBox "Hello",vbOKCancel AND vbOKCancel
>
>
> does.
>
>
> Vanderghast, Access MVP

Er, shouldn't that be OR?