Determine if an ADO Field's Type is a String

Category:
Database
Type:
Snippets
Difficulty:
Beginning
Author:
Intelligent Solutions Inc.

Version Compatibility:

More information:
This function takes an ADO field object as a parameter and returns true if that field's type evaluates to a VB string. It could be useful in constructing SQL strings based on ADO fields in a recordset (e.g., to determine whether or not to add a single quote to Where Clause criteria).

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

Declarations:

Code: