Convert Null Values From a RecordSet into Strings -- Yet Another Method

Category:
String Manipulation
Type:
Snippets
Difficulty:
Beginning
Author:
Sean Page

Version Compatibility:

More information:
When assigning string values from a recordset that can be null, append a zero-length string to them. This makes them no longer null, and doesn't modify correctly populated strings.

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

Declarations:

Code: