Skip to main content

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.

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.

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.

Int()

The Fix() and Int() functions both remove the fractional part of a number and returns the restulting integer.  The difference between the two is that if a number is negative Int() returns the first negative integer less than or equal to the number while Fix returns the first negative integer greater than or equal to the numer.

Fix()

The Fix() and Int() functions both remove the fractional part of a number and returns the restulting integer.  The difference between the two is that if a number is negative Int() returns the first negative integer less than or equal to the number while Fix returns the first negative integer greater than or equal to the numer.

Randomize()

This is used to create a seed value for the Rnd() function, this helps vary the output of the random seed.  You would place a number as the seed, one good option is to use the Second(Now()), this would make sure that your seed is different every time you run the script.