contents.gifindex.gifprev1.gifnext1.gif

CVar

Purpose

Explicitly converts an expression from one data type to the variant data type.

Arguments

CVar( expression )

Notes

A variant can store numeric, string, date/time, null, or empty data

Example

CVar takes a String value expressed in thousands for sales from a quarterly report, concatenates three zeros, and converts the entire expression to a Variant.

X = CVar( Sales$ & "000" )