[AccessD] Checking for Optional Parameters

Arthur Fuller fuller.artful at gmail.com
Tue Jan 24 06:46:59 CST 2023


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


More information about the AccessD mailing list