Typecasting allows you to convert between data subtypes.

Typecasting Functions

§ CInt(expression) casts expression to an integer. If expression is a

floating-point value or a currency value, it is rounded. If it is a string that

looks like a number, it is turned into that number and then rounded if

necessary. If it is a Boolean value of True, it becomes -1. False becomes 0.

It also must be within the range that an integer can store.

§ CByte(expression) casts expression to a byte value provided that

expression falls between 0 and 255. expression should be numeric or

something that can be cast to a number.

§ CDbl(expression) casts expression to a double, expression should be

numeric or something that can be cast to a number.

§ CSng(expression) casts expression to a single. It works like CDbl(), but

must fall within the range represented by a single.

§ CBool(expression) casts expression to a Boolean value. If expression is

zero, the result is False. Otherwise, the result is True. Expression should be

numeric or something that can be cast to a number.

§ CCur(expression) casts expression to a currency value, expression

should be numeric or something that can be cast to a number.

§ CDate(expression) casts expression to a date value, expression should

be numeric or something that can be cast to a number, or a string of a

commonly used date format. DateValue(expression) or TimeValue

(expression) can also be used for this.

§ CStr(expression) casts expression to a string, expression can be any

kind of data.