Jobs
Author: Raghuraja. C Date Submitted: 2/17/2005 Category: Other Compatibility: VB 6 This code has been accessed 3680 times.
Email Yourself this snippet:
No Decalaration
Code
Public Function fnNULL(strPVAL) As String '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
