Section A.5. Data Type Conversion

Asc Function

Returns the ASCII code for a character

AscW Function

Returns the Unicode code for a character

CBool Function

Converts a value to a Boolean

CByte Function

Converts a value to a Byte

CCur Function

Converts a value to Currency

CDate Function

Returns a Date data type

CDbl Function

Converts a value to a Double

Chr Function

Returns the character corresponding to a numeric ASCII code

ChrW Function

Returns the character corresponding to a particular Unicode value

CInt Function

Converts a value to an Integer

CLng Function

Converts a value to a Long

CSng Function

Converts a value to a Single

CStr Function

Converts a value to a String

DateSerial Function

Returns a date from valid year, month, and day values

DateValue Function

Returns a date from any valid date expression

Fix Function

Returns an integer portion of number

Hex Function

Returns a hexadecimal representation of a number

Int Function

Returns the integer portion of a number

Oct Function

Returns an octal representation of a number

TimeSerial Function

Returns a date from valid hour, minute, and second values

TimeValue Function

Returns a date value from any valid time expression