Optional argument in function call.

[Robeen]

Hi,

Will SomeValue be Null if no value is passed for it when the function below is called?

Function(SQLString as String, Optional SomeValue as String) As Long



Thanks!

[CJ_London]

no it will be missing

if ismissing(Somevalue) then msgbox "Somevalue has not had a value passed in the parameters"

[Robeen]

Thanks! I appreciate your help!