by Raghuraja. C (21 Submissions)
Category: Miscellaneous
Compatability: VB 6.0
Difficulty: Unknown Difficulty
Originally Published: Thu 17th February 2005
Date Added: Mon 8th February 2021
Rating: (1 Votes)
To Validate Database Null Values
'To validate NULL value
On Error GoTo LOCALERRORHANDLER
If IsNull(strPVAL) Then
fnNULL = ""
Else
If IsNumeric(strPVAL) Then
fnNULL = strPVAL
Else
If strPVAL <> "" Then
fnNULL = Replace(strPVAL, " ", " ")
End If
End If
End If
Exit Function
LOCALERRORHANDLER:
fnNULL = ""
End Function