Convert Null Values From a RecordSet into Strings -- Yet Another Method
Category:
String ManipulationType:
SnippetsDifficulty:
BeginningAuthor:
Sean PageVersion 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: