Function Fix Ups Class

FixUpVariantToStringFnRecursive

"Fix Up Variant To String Function Recursive" Convert the elements of a Variant array to string values. Function leaves string valued elements as-is, and converts numeric or date type elements into string values. Return False if any cannot be converted to a string.

Signature (Visual Basic / VBA)

Public Function FixUpVariantToStringFnRecursive( _
      ByRef rArgument As Variant _
    ) As Boolean

Parameters

Parameter Description
rArgument The argument which is converted into a string value, if possible. Function stops and returns False if any individual element cannot be converted, such as when the argument is missing, Null, an array, an error, or an object. Function returns True if all elements either had string values or were converted to string values.

Notes & Version History

Note Function handles arguments containing nested Array-type Variant values.
Note rArgument is a passed by reference, so the array passed from the calling function may be modified.
Note Function silently ignores vbDataObject and vbObject type values.
v1.3 BugFix Changed this function to correctly do nothing when the argument is of type dbDataObject.