[AccessD] Checking for Optional Parameters

John Colby jwcolby at gmail.com
Tue Jan 24 16:21:28 CST 2023

Named params allow you to pass them in any order because you now use the
syntax "ParamA - 1234", IOW you can actually tell the function which params
you are passing in what order by specifying the name.

On Tue, Jan 24, 2023 at 7:47 AM Arthur Fuller <fuller.artful at gmail.com>

> I keep forgetting which check to use to determine whether or not an
> optional parameter was passed to a function.
> <code>
> Function myFunc( Optional d as Date ) as <whatever>
> 'is it:
> If IsMissing( d) or
> If IsNull(d) or ?
> </code>
> Side question: As a matter of coding style, do you use named parameters in
> your own functions (i.e. as in, say, a call to MsgBox, which gives you that
> prompt that walks you through the syntax as you type)?
> --
> Arthur
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com

John W. Colby
Colby Consulting

More information about the AccessD mailing list