Convert Null Values into Strings -- Alternative Method

Category:
String Manipulation
Type:
Snippets
Difficulty:
Beginning
Author:
Andrew Ells-O'Brien

Version Compatibility: Visual Basic 6

More information:
This function is useful for avoiding the invalid use of null error when reading values for a database resultset.

This function eliminates the need for "On Error Resume Next" code.

Instructions: Copy the declarations and code below and paste directly into your VB project.

Declarations:

Code: