Can vbNullString be used in VBA as well as VB4-6? 1

[kjv1611]

I came accross an old thread, thread222-259902 , as a suggested reading on the topic of using null values. My question is can [blue]vbNullString]/blue] be used in VBA for Microsoft Applications (specifically Access), or no?

Stephen
"Jesus saith unto him, I am the way, the truth, and the life:
no man cometh unto the Father, but by me." John 14:6 KJV

 

[jpittawa]

Yes. I just tested it with Access 2003.

Public Function vbNullStringTest()
Dim s As String

If s = vbNullString Then
s = "It works"
Else
s = "It fails"
End If
Debug.Print s
End Function

Immediate Window:
?vbNullStringTest()
It works

 

[kjv1611]

Thanks for the input!

Stephen
"Jesus saith unto him, I am the way, the truth, and the life:
no man cometh unto the Father, but by me." John 14:6 KJV