Is this a normal behavior in Access? (1 Viewer)

[KitaYama]

That is impossible to know,

If after the ")" is empty, doesn't it mean there's no retruning value for the function?
I assume As is used for this purpose.

Function test()              ' has no returning value
vs
Function test() As String    ' has retruning value

 

[Josef P.]

Function test() ' has no returning value

is equal to

Function test() as Variant

In principle, functions behave in the same way as variables.

Dim X as String
Dim Y   ' ... equals: Dim Y as Variant

 

[KitaYama]

is equal to

Function test() as Variant

Thanks. I didn't know that.
I think it explain it all.

 

[sonic8]

If after the ")" is empty, doesn't it mean there's no retruning value for the function?

No. It's the very definition of a function that is has a return value. If you want a method to not have a return value, you must write a Sub.

Public Function TestWithNoExplicitReturnValue()
End Function

Public Sub TestTheReturnValue()

    Dim dummy As Variant
    dummy = "Not empty"
    
    dummy = TestWithNoExplicitReturnValue
    
    If IsEmpty(dummy) Then
        MsgBox "dummy is now empty because that was what the function returned."
    End If

End Sub

 

[Josef P.]

Unfortunately, this is the “comfort functionality” of VBA/VB6 that I would prefer to turn off.

 

[sonic8]

Unfortunately, this is the “comfort functionality” of VBA/VB6 that I would prefer to turn off.

Option Strict
Unfortunately, not available in VBA.

 

[The_Doc_Man]

Slightly weird, that this works without the Set keyword, but that's beyond the scope of the original question.

In the case referenced, the "t = ...." (as opposed to "Set t = ...") is assumed to be referencing the default property of the item to the right of the equals-sign as a possible source for T, which IS declared as a variant. Given the vagaries of late binding, I believe Access compiles the statement and is merely waiting until run-time to see if that right-hand object or variable actually exists when the code is executed.