Conversion

CStr()

The CStr() will convert numeric and date values to a string format. 

CSng()

This function will change a number into a single type.  A single type has 4 decimals so any decimals larger than 4 will be rounded to 4.

CLng()

This functions changes a number into a long type.

CInt()

Converts a numeric expression into one of an integer data type.  In the example below when we changed a double into an integer the fractional portion is rounded.

CDbl()

This conversion will change a number into a number of type double.

CDate()

This function converst a valid date or time expression that is currently a string into a date type.  The expression can contain only the date, only the time or both.

Cbool()

Converst an expression into a boolean.  So if the expression is true, i.e. 5 = 5 then it would return True, if it is false, i.e. 5 = 6 then it would return false.

Asc()

The Asc() function will return the ASCII code for the character.  It a string is placed in the function it will only return the ASCII code for the first character.

Subscribe to RSS - Conversion