[AccessD] Checking for Optional Parameters

Jim Dettman jimdettman at verizon.net
Tue Jan 24 07:04:57 CST 2023

Is Missing:



-----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.

Function myFunc( Optional d as Date ) as <whatever>
'is it:
If IsMissing( d) or
If IsNull(d) or ?

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)?

AccessD mailing list
AccessD at databaseadvisors.com
Website: http://www.databaseadvisors.com

More information about the AccessD mailing list