collection is missing from arguments

[Anishtain4]

How should I understand if an optional arguments which is collection is missing? as it seems when you don't pass it, that gets the Nothing and Nothing is not missing, so the IsMissing function won't work for it

 

[JANR]

IsMissing only works for Variant datatypes. Look in Access help for the use of IsMissing.

JR

 

[spikepl]

IsMissing works for Variant-type argument only : http://office.microsoft.com/en-us/access-help/ismissing-function-HA001228866.aspx

 

[Anishtain4]

Yep I got that, but the way to check if an object is missing is: sub test(optional var as object) ..... if (variable is nothing) then ......

 

[gemma-the-husky]

no the way to test is using

if ismissing(optionalvar)

and this test can ONLY BE TRUE for a variant parameter - as typed parameters are initialised to a default value, and can never be missing


so

myfunc(optional somevar)
- you can detect somevar as missing ie - not passed by the calling code

BUT

myfunc(optional somevar as long)
- you can not detect somevar as missing, since if it is not passed by the call, it is initiallised to 0