[AccessD] Checking for Optional Parameters

[Jim Dettman]

Is Missing:

https://learn.microsoft.com/en-us/office/vba/language/reference/user-interfa
ce-help/ismissing-function

Jim.

-----Original Message-----
From: AccessD On Behalf Of Arthur Fuller
Sent: Tuesday, January 24, 2023 7:47 AM
To: Access Developers discussion and problem solving
<accessd at databaseadvisors.com>
Subject: [AccessD] Checking for Optional Parameters

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